Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula doesn't show
Hi all
Strange question........ My colleague has a worksheet and she has entered a formula into a cell but when you press enter, it still shows the formula rather than the answer. I have checked Tools, Options, View, Formulas which isn't checked and we have also made sure that the calcualations are set to update automatically. She has just sent me the worksheet via e-mail and when I do the same calculation on my own PC, it works fine? Anybody know what the problem is? Thank you. Louise |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula doesn't show
Based on how often I've seen this come up since I started viewing this forum,
this seems to be a pretty common problem. Based on what you said, I would say that the cell was formatted as text before the formula was entered. Try changing the format to General, and then hit F2 (to edit the formula) and press return. The results should now show. HTH -- Kevin Vaughn "Louise" wrote: Hi all Strange question........ My colleague has a worksheet and she has entered a formula into a cell but when you press enter, it still shows the formula rather than the answer. I have checked Tools, Options, View, Formulas which isn't checked and we have also made sure that the calcualations are set to update automatically. She has just sent me the worksheet via e-mail and when I do the same calculation on my own PC, it works fine? Anybody know what the problem is? Thank you. Louise |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula doesn't show
If the formula appears in both the cell and formula bar, then the cell is
probably formatted as text. 1. clear the cell Edit Clear All 2. re-enter the formula via typing (NOT pasting) -- Gary's Student "Louise" wrote: Hi all Strange question........ My colleague has a worksheet and she has entered a formula into a cell but when you press enter, it still shows the formula rather than the answer. I have checked Tools, Options, View, Formulas which isn't checked and we have also made sure that the calcualations are set to update automatically. She has just sent me the worksheet via e-mail and when I do the same calculation on my own PC, it works fine? Anybody know what the problem is? Thank you. Louise |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula doesn't show
Thanks very much for your reply. It worked.
Louise "Kevin Vaughn" wrote: Based on how often I've seen this come up since I started viewing this forum, this seems to be a pretty common problem. Based on what you said, I would say that the cell was formatted as text before the formula was entered. Try changing the format to General, and then hit F2 (to edit the formula) and press return. The results should now show. HTH -- Kevin Vaughn "Louise" wrote: Hi all Strange question........ My colleague has a worksheet and she has entered a formula into a cell but when you press enter, it still shows the formula rather than the answer. I have checked Tools, Options, View, Formulas which isn't checked and we have also made sure that the calcualations are set to update automatically. She has just sent me the worksheet via e-mail and when I do the same calculation on my own PC, it works fine? Anybody know what the problem is? Thank you. Louise |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
formula doesn't show
You're welcome.
-- Kevin Vaughn "Louise" wrote: Thanks very much for your reply. It worked. Louise "Kevin Vaughn" wrote: Based on how often I've seen this come up since I started viewing this forum, this seems to be a pretty common problem. Based on what you said, I would say that the cell was formatted as text before the formula was entered. Try changing the format to General, and then hit F2 (to edit the formula) and press return. The results should now show. HTH -- Kevin Vaughn "Louise" wrote: Hi all Strange question........ My colleague has a worksheet and she has entered a formula into a cell but when you press enter, it still shows the formula rather than the answer. I have checked Tools, Options, View, Formulas which isn't checked and we have also made sure that the calcualations are set to update automatically. She has just sent me the worksheet via e-mail and when I do the same calculation on my own PC, it works fine? Anybody know what the problem is? Thank you. Louise |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
leading zeros are not showing in the formula bar but do show in ce | Excel Discussion (Misc queries) | |||
formula to show 97.826 as 97.825 | Excel Discussion (Misc queries) | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
My formula will not show the result, only the formula. | Excel Worksheet Functions | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions |