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?
|