I think you have to re-enter the formula *after* you reformat the cell.

Rick


"Kimbanev" wrote in message
...
Sometimes a cell's formula displays on my worksheet instead of the
calculation. Why does this happen, and how can I fix it? I've tried
re-formatting the cell, but this does not fix the problem.