Excell only displays the formula, not the results

R

René

Both the target cell a destination cell are formatted as general and unlocked.
I tried switching Formula auditing on/off, but nothing happens
Now what?
 
R

RagDyeR

Click in the cell, then:
<F2> <Enter>

If the formula was entered while the format was text, just changing the
format to General or Number afterwards doesn't work.
You have to re-enter the formula.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

Both the target cell a destination cell are formatted as general and
unlocked.
I tried switching Formula auditing on/off, but nothing happens
Now what?
 
D

Dave Peterson

And if all the formulas show--but not the results, maybe you toggled:

Tools|options|View tab|uncheck formulas

this can be toggled by hitting ctrl-`
(control-backquote, to the left of the the 1/! on my USA keyboard)
 
Top