ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Prolblem entering simple Formulae (https://www.excelbanter.com/excel-discussion-misc-queries/93887-prolblem-entering-simple-formulae.html)

Andy

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?




Andy

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