Formula stays visible in cell

T

Trev

When I entered a formula into a cell it stays visible. I have tried several
different styles of format and the only change I have been able to get
resulted in a #ref error. Any ideas would help.

Thanks
Trev
 
D

Dave Peterson

Try formatting the cell as General (or anything but text).
Then reenter the formula.

Or

Try tools|Options|View tab|and uncheck Formulas
(xl2003 menus)
 
T

Tom Hutchins

The cell may have been formatted as text before the formula was entered.
Select the cell, then right-click and select Format Cells. Format the cell as
General (on the Number tab), then click OK. Press F2, then Enter.

Another possibility is that you have accidentally toggled the view to
display formulas rather than their results. Pressing Ctrl ` to toggle the
view back to normal (` is to the left of the number 1).

Hope this helps,

Hutch
 
T

Trev

I am using 2007.

Dave Peterson said:
Try formatting the cell as General (or anything but text).
Then reenter the formula.

Or

Try tools|Options|View tab|and uncheck Formulas
(xl2003 menus)
Click to expand...
 
Top