![]() |
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? |
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? |
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? |
All times are GMT +1. The time now is 03:15 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com