| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Why do formulas appear and not the result?
Even though I have unchecked the option to show formulas instead of their
result, I still get the formula appearing when I insert a new formula, all the old ones show the result, it's just when I add a new one. Any ideas? Thanks |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Why do formulas appear and not the result?
Check the format of the cell. Right clickFormat cell...Change that to
general...from text -- If this post helps click Yes --------------- Jacob Skaria "Brian Cook" wrote: Even though I have unchecked the option to show formulas instead of their result, I still get the formula appearing when I insert a new formula, all the old ones show the result, it's just when I add a new one. Any ideas? Thanks |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Why do formulas appear and not the result?
Thanks Jacob,
I've just tried that and it didn't work. ----------------------------------------- "Jacob Skaria" wrote: Check the format of the cell. Right clickFormat cell...Change that to general...from text -- If this post helps click Yes --------------- Jacob Skaria "Brian Cook" wrote: Even though I have unchecked the option to show formulas instead of their result, I still get the formula appearing when I insert a new formula, all the old ones show the result, it's just when I add a new one. Any ideas? Thanks |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Why do formulas appear and not the result?
"Brian Cook" wrote:
Even though I have unchecked the option to show formulas instead of their result, I still get the formula appearing when I insert a new formula, all the old ones show the result, it's just when I add a new one. Any ideas? The cell is probably formatted as Text. Change the format to General or some other appropriate format by clicking on Format Cells Number. Then press F2 and Enter (or ctrl-shift-Enter for array formulas). The latter step is needed to coerce Excel into reprocessing the formula as if you had edited it. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Why do formulas appear and not the result?
After changing to General you must re-enter each formula.
F2 then ENTER If you have a great many of these use editreplace What: = With: = Replace all. Gord Dibben MS Excel MVP On Thu, 28 May 2009 06:11:01 -0700, Brian Cook wrote: Thanks Jacob, I've just tried that and it didn't work. ----------------------------------------- "Jacob Skaria" wrote: Check the format of the cell. Right clickFormat cell...Change that to general...from text -- If this post helps click Yes --------------- Jacob Skaria "Brian Cook" wrote: Even though I have unchecked the option to show formulas instead of their result, I still get the formula appearing when I insert a new formula, all the old ones show the result, it's just when I add a new one. Any ideas? Thanks |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| changing formulas to their result values | Excel Discussion (Misc queries) | |||
| Formulas never show result??? | Excel Discussion (Misc queries) | |||
| Two identical formulas for a different result? | Excel Discussion (Misc queries) | |||
| how can i use colors in conditional formulas if i want the result. | Excel Discussion (Misc queries) | |||
| Formulas appear in cell instead of formula result | Excel Worksheet Functions | |||
Linear Mode
