ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   cells will not calculate (https://www.excelbanter.com/excel-worksheet-functions/36608-cells-will-not-calculate.html)

jch2005

cells will not calculate
 

I am having a problem where formulas won't calculate. The cells just
display text!
Even the formula:

= 9 + 2

will not calculate. Is this a new problem with Excel 2003?

MUCH TIA, j


--
jch2005
------------------------------------------------------------------------
jch2005's Profile: http://www.excelforum.com/member.php...o&userid=25481
View this thread: http://www.excelforum.com/showthread...hreadid=389329


Niek Otten

Your cells were formatted as text before you entered the formula. Format as
General and re-enter the formula (F2, ENTER)
Or, you accidentally pressed CTRL+`
If so, press again

--
Kind regards,

Niek Otten

Microsoft MVP - Excel

"jch2005" wrote in
message ...

I am having a problem where formulas won't calculate. The cells just
display text!
Even the formula:

= 9 + 2

will not calculate. Is this a new problem with Excel 2003?

MUCH TIA, j


--
jch2005
------------------------------------------------------------------------
jch2005's Profile:
http://www.excelforum.com/member.php...o&userid=25481
View this thread: http://www.excelforum.com/showthread...hreadid=389329





All times are GMT +1. The time now is 05:41 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com