formulas appear in cell as entered..

G

GeneWan

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!
 
R

Roger Govier

Hi

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

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
 
Top