IF function results not displayed in cell

[Guest]

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.

 

[T. Valko]

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