formulas appear in cell as entered..
 

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!

formulas appear in cell as entered..
 

Hi

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

--
Regards

Roger Govier


"GeneWan" wrote in message
...
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!

formulas appear in cell as entered..
 

the cell is formatted as TEXT:format cell as General
"GeneWan" wrote in message
...
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!

formulas appear in cell as entered..
 

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

"GeneWan" wrote in message
...
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!