Try formatting the cell to GENERAL. Then, with the cell still selected hit
function key F2 then hit ENTER.

--
Biff
Microsoft Excel MVP


"mrcpuhead" wrote in message
...
I've added a correctly formatted IF statement to a Text cell in a
worksheet
(Excel 2003), but instead of showing the result, it shows the formula in
the
cell.
I've tried the Ctrl ` key combo - that doesn't help.
Even if I then replace the cell's contents with a simple reference to
another cell (for example =G23), the cell shows the reference instead of
the
value of the other cell.