the times this happens most often is when you have copied and pasted values
and when you are in edit mode and press F9
do you have macros running which either paste values or calculate as a
portion

"Joe" wrote:

Hi there. Sometimes the formula in the cell dissapears eg
=890/1000

to just showing 0.89

I want to keep the formula in the cell. So I know where the value comes from
if I need to refer to it in the future.
Thanks,jose