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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Chris Bowling - 28 Feb 2006 15:17 GMT

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

Reply to this Message

davesexcel - 28 Feb 2006 15:33 GMT

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

Signature

davesexcel

Reply to this Message

Bernard Liengme - 28 Feb 2006 17:22 GMT

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

Signature

Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

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

Reply to this Message