Your cell may be formatted as text. If that isn't the case, press Ctrl-~ or
go to Tools-Options-View and uncheck formulas



"Dean" wrote:

When I edit the formula in a cell displaying a value, when I am done editing,
the formula is displayed, not the value.