Formulas arent calculating?

[hallingh]

I have a worksheet filled with formulas. All of them work fine, except for any formula I type into cell F1. For whatever reason, in that cell this text:

=VALUE('Raw Infopath Data (BAT)'!F3)

comes out as "=VALUE('Raw Infopath Data (BAT)'!F3)" instead of the actualy result of the formula. I have tried simple formulas as well, like:

=A2

but it still has the same error. Anyone know what the issue might be? Thanks!

Hank

 

[wigi]

Hello

Format the cells in that column as General (for instance) and then you can use formulas instead of Text.

 

[hallingh]

Ah, that worked. Didn't think of that because I had never changed the format to general..

Thanks for the help!