| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Prolblem entering simple Formulae
I've just been upgraded to excel 2003 and if I enter a simple formula into
excel such as =2+2, instead of giving me the answer 4 the cell just displays =2+2. How do I resolve this? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Prolblem entering simple Formulae
Hi
Your cell may have been formatted as Text. Format your cell as General and re-enter the formula. Also worth checking Tools/Options/View and make sure that Formulas is not checked. Hope this helps. Andy. "Andy" wrote in message ... I've just been upgraded to excel 2003 and if I enter a simple formula into excel such as =2+2, instead of giving me the answer 4 the cell just displays =2+2. How do I resolve this? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Prolblem entering simple Formulae
Thanks for that, it was the formulas checkbox in options.
"Andy" wrote: Hi Your cell may have been formatted as Text. Format your cell as General and re-enter the formula. Also worth checking Tools/Options/View and make sure that Formulas is not checked. Hope this helps. Andy. "Andy" wrote in message ... I've just been upgraded to excel 2003 and if I enter a simple formula into excel such as =2+2, instead of giving me the answer 4 the cell just displays =2+2. How do I resolve this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| simple if then function | Excel Worksheet Functions | |||
| Simple Simple Excel usage question | Excel Discussion (Misc queries) | |||
| Help with what should be a simple formula | Excel Worksheet Functions | |||
| Formulae, conditional formatting & macro security | Excel Discussion (Misc queries) | |||
| Simple But Stumped | Excel Discussion (Misc queries) | |||
Linear Mode
