| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
calculation
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
calculation
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
calculation
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
calculation
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
calculation
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
calculation
Is the worksheet protected?
Yes, actually. Why is that relevant? 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) "Joe" wrote in message ... 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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
calculation
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculation | Excel Worksheet Functions | |||
| calculation | Excel Discussion (Misc queries) | |||
| Once only calculation - help please | Excel Discussion (Misc queries) | |||
| How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
| How do I use a rounded calculation result in another calculation? | Excel Worksheet Functions | |||
Linear Mode
