Hi

If this is happening for all the formulas then press Ctrl ` (the apostrophy
to the left of the 1 key on most keyboards)

If this is only happening in some cells then the problem is probably that
the cell is formatted to text - choose Format, Cells, Number tab, change the
format, then reenter the formula.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"dizzzy lizzzzy" wrote:

I have spreadsheet that keeps showing the formula in the cell and not the
result of the formula. I am trying to change a text eg 0908 to a time eg
09:09:00