Excell only displays the formula, not the results
 

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?

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!
==============================================

"René" wrote in message
...
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?

All formulas begin with an "=" (without the quote marks).
=SUM()


"RagDyeR" wrote in message
...
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!
==============================================

"René" wrote in message
...
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?

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)

René wrote:

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?

--

Dave Peterson