Relevant if the cells are set to hidden under FormatCellsProtectionHidden


Gord Dibben MS Excel MVP


On Thu, 23 Aug 2007 07:32:04 -0700, Joe wrote:

Yes, actually. Why is that relevant?

"Bob Phillips" wrote:

Is the worksheet protected?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Joe" wrote in message
...
The formula is not in the formula bar any longer. It dissapears for not
reason. Sometimes it is, sometimes is not

"Bob Phillips" wrote:

The formula is still there. When you select the cell, you can see it in
the
formula bar.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"Joe" wrote in message
...
Hi there,
Sometimes the formula in the cell dissapears eg
=890/1000

I get 0.89 instead. but I would like to see the formula so I can refer
to
in
the future. Do you know what can be wrong?
thanks,jose