View Single Post
  #2   Report Post  
Old December 28th 04, 10:37 AM
RagDyeR
 
Posts: n/a
Default

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