calculation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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)
 
The formula is not in the formula bar any longer. It dissapears for not
reason. Sometimes it is, sometimes is not
 
Is the worksheet protected?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Yes, actually. Why is that relevant?

Bob Phillips said:
Is the worksheet protected?

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
Click to expand...
 
Is the worksheet protected?
Yes, actually. Why is that relevant?
Click to expand...

If the "Hidden" property of the cell is True, the formula will not be
visible in the formula bar while the worksheet is protected. If it is
unprotected, the formula is visible. Protect the sheet and the formula is
not visible.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)
 
Relevant if the cells are set to hidden under Format>Cells>Protection>Hidden


Gord Dibben MS Excel MVP
 
Back
Top