When inserting a simple "Sum" formula all I get is the formula.
 

I need to see the calculation and not the formula. I've used this process for
years and have never had problems.

When inserting a simple "Sum" formula all I get is the formula.
 

goto tools=options=view and make sure formulas are not ticked off


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=517335

When inserting a simple "Sum" formula all I get is the formula.
 

1) Make sure the cell is not formatted Text; if so, format it General then
open the cell (F2 or double click) then Enter.
2) Make sure you do not have View Formulas on: hold CTRL+` (the key to left
of 1 on top row of so-called typewriter keys)
If nothing works: enter some simple formula { =A1+A2 } somewhere and tell us
what results
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Chris Bowling" <Chris wrote in message
...
I need to see the calculation and not the formula. I've used this process
for
years and have never had problems.