Formula won't hide

K

Karen

Office 2003

I run into this problem from time to time: the formula in a particular cell
displays even when other formulas in the worksheet do not display unless
turned on by CTRL`.

TIA
Karen
 
E

Elkar

I'm guessing that the cell may have been preformatted as text before the
formula was entered. Try changing the cell format to General, then
reentering the formula (press F2 then Enter).

HTH,
Elkar
 
Top