The cell is presumably formatted as text. Format as General (or Number) and
re-enter the formula.
--
David Biddulph

"nv77078" wrote in message
...
Everytime I visit a cell with a formula in a certain column of my
worksheet
and press enter, that cell will only show the formula instead of the
result.
Any idea on how to show the result back again for those cells?
Nancy