Editing cell and showing value

J

John Pappas

My problem is editing inside a cell that contains a nested if formula.
After editing the cell and pressing return the cell places the 'formula' and
not the 'value resulting from the formula' in the cell. I keep checking if
it is protected but to no avail. Does anyone have any thioughts on this?
Thanks in advance.

John
 
D

Dave Peterson

Try changing the format of the cell to Number (or anything but Text).
(Format|Cells|Number tab)

Then select that cell, hit F2 and enter (to reenter the formula).
 
Top