formulas appear in cell as entered..

[Guest]

whatever function (eg. "=sum(A1:A10)") I typed into the cell, the formula
just appeared as normal text, displaying exactly what I typed in.

how can I get it to work?

I do not think this is due to the manual calculation update option, as it
has been set to automatic..

any help is appreciated.. thanks!

 

[Roger Govier]

Hi

Try pressing Ctrl +` (that's the Control button and the key above Tab
and left of 1

 

[toppers]

the cell is formatted as TEXT:format cell as General

 

[Paul B]

Gene, sounds like the cell is formatted as text, format to general or
something else and reenter the formula
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003