| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel shows formula, not result
Help! I have a conditional formula that will not show the result. It shows
only the formula. Right now, the formulas box in the view tab under tools/options is UNCHECKED and the formula still shows. I've tried checking the box and it still shows. I really need my result in the cell and the day is getting away from me...(Excel 2000) |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel shows formula, not result
This may seem obvious, but is there an " = " sign in the cell before your
formula...? "CMIConnie" wrote: Help! I have a conditional formula that will not show the result. It shows only the formula. Right now, the formulas box in the view tab under tools/options is UNCHECKED and the formula still shows. I've tried checking the box and it still shows. I really need my result in the cell and the day is getting away from me...(Excel 2000) |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel shows formula, not result
Your cell may be formatted as "text", format as "general" or "number" then
hit F2 and Enter. HTH JG "ewan7279" wrote: This may seem obvious, but is there an " = " sign in the cell before your formula...? "CMIConnie" wrote: Help! I have a conditional formula that will not show the result. It shows only the formula. Right now, the formulas box in the view tab under tools/options is UNCHECKED and the formula still shows. I've tried checking the box and it still shows. I really need my result in the cell and the day is getting away from me...(Excel 2000) |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel shows formula, not result
yes, it has an "=" sign before the formula. Someone just suggested checking
the format so I will check that... Thank you "ewan7279" wrote: This may seem obvious, but is there an " = " sign in the cell before your formula...? "CMIConnie" wrote: Help! I have a conditional formula that will not show the result. It shows only the formula. Right now, the formulas box in the view tab under tools/options is UNCHECKED and the formula still shows. I've tried checking the box and it still shows. I really need my result in the cell and the day is getting away from me...(Excel 2000) |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel shows formula, not result
Thank you! Thank you! Thank you! it worked! I love this site... now maybe I
can get this done :) "pinmaster" wrote: Your cell may be formatted as "text", format as "general" or "number" then hit F2 and Enter. HTH JG "ewan7279" wrote: This may seem obvious, but is there an " = " sign in the cell before your formula...? "CMIConnie" wrote: Help! I have a conditional formula that will not show the result. It shows only the formula. Right now, the formulas box in the view tab under tools/options is UNCHECKED and the formula still shows. I've tried checking the box and it still shows. I really need my result in the cell and the day is getting away from me...(Excel 2000) |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel shows formula, not result
It seems strange, that's all. Even with a cell formatted as text, the
formula should still return the result... Try entering the formula with ctrl+shift+enter. "CMIConnie" wrote: yes, it has an "=" sign before the formula. Someone just suggested checking the format so I will check that... Thank you "ewan7279" wrote: This may seem obvious, but is there an " = " sign in the cell before your formula...? "CMIConnie" wrote: Help! I have a conditional formula that will not show the result. It shows only the formula. Right now, the formulas box in the view tab under tools/options is UNCHECKED and the formula still shows. I've tried checking the box and it still shows. I really need my result in the cell and the day is getting away from me...(Excel 2000) |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel shows formula, not result
Another possible option when Excel is showing Formulas is that the option to
show "Formulas" is turned on. Tools | Options | "View Tab" With a check on "Formulas" One can toggle between both views with Ctrl + ` (Character to left of number 1, usually with ~ character) -- HTH. :) Dana DeLouis Windows XP, Office 2003 "ewan7279" wrote in message ... It seems strange, that's all. Even with a cell formatted as text, the formula should still return the result... Try entering the formula with ctrl+shift+enter. "CMIConnie" wrote: yes, it has an "=" sign before the formula. Someone just suggested checking the format so I will check that... Thank you "ewan7279" wrote: This may seem obvious, but is there an " = " sign in the cell before your formula...? "CMIConnie" wrote: Help! I have a conditional formula that will not show the result. It shows only the formula. Right now, the formulas box in the view tab under tools/options is UNCHECKED and the formula still shows. I've tried checking the box and it still shows. I really need my result in the cell and the day is getting away from me...(Excel 2000) |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel shows formula, not result
It is strange... I formated it as a number and it worked. It is a huge
spreadsheet (over 7000 rows) so maybe that has something to do with it. but it is working now so that's okay with me :) "ewan7279" wrote: It seems strange, that's all. Even with a cell formatted as text, the formula should still return the result... Try entering the formula with ctrl+shift+enter. "CMIConnie" wrote: yes, it has an "=" sign before the formula. Someone just suggested checking the format so I will check that... Thank you "ewan7279" wrote: This may seem obvious, but is there an " = " sign in the cell before your formula...? "CMIConnie" wrote: Help! I have a conditional formula that will not show the result. It shows only the formula. Right now, the formulas box in the view tab under tools/options is UNCHECKED and the formula still shows. I've tried checking the box and it still shows. I really need my result in the cell and the day is getting away from me...(Excel 2000) |
|
#9
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Excel shows formula, not result
I may be wrong but I think it depends on when the cell was formatted. If the
cell was pre-formatted as text and you enter the formula then the formula will show as text, if however you format the cell after the formula was entered then the result will be text not the formula but if you re-enter the formula while the cell is formatted as text then the formula will turn back into text. Regards Jean-Guy "ewan7279" wrote: It seems strange, that's all. Even with a cell formatted as text, the formula should still return the result... Try entering the formula with ctrl+shift+enter. "CMIConnie" wrote: yes, it has an "=" sign before the formula. Someone just suggested checking the format so I will check that... Thank you "ewan7279" wrote: This may seem obvious, but is there an " = " sign in the cell before your formula...? "CMIConnie" wrote: Help! I have a conditional formula that will not show the result. It shows only the formula. Right now, the formulas box in the view tab under tools/options is UNCHECKED and the formula still shows. I've tried checking the box and it still shows. I really need my result in the cell and the day is getting away from me...(Excel 2000) |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can I make a formula in Excel to display result in same cell? | Excel Worksheet Functions | |||
| Can an IF formula result in a color filled cell in Excel? | Excel Worksheet Functions | |||
| Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions | |||
| Why does the formula result show a number but the screen shows ze. | Excel Worksheet Functions | |||
| Excel 2003 - Formula result shows as 0:00 | Excel Worksheet Functions | |||
Linear Mode
