Excel wont calculate formulas

  • Thread starter Thread starter arunsharm82
  • Start date Start date
A

arunsharm82

Hi
I dont know what I did, but Excel wont calculate formulas for me.
When I type one in and click enter it just displays the formula.
What have I done!?!? and how do I fix it!

Please help

Thanks:confused
 
Your cells are likely to be formatted as Text.
Select the cells concerned and : Format / Cells / Number Tab / General

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *
 
Hi
you may have formated the cell as 'Text'. Goto 'Format - Cell' and
change the format to 'General'. Reenter your formula
 
Also, you might have switch to "formulas view" accidentally by pressing
Ctrl-`. You can press it again to toggle out or uncheck Tools, Options,
View, Formulas
 
Back
Top