| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| HOW NOT TO CALCULATE CELLS IF ONE CONTAINS "0" | Excel Worksheet Functions | |||
| Blank Cells in Pivot Tables | Excel Discussion (Misc queries) | |||
| calculate percentage of two cells | Excel Worksheet Functions | |||
| Protected cells -automatically format to a different color | Excel Discussion (Misc queries) | |||
| calculate the sum of cells where values are between 6 and 10 in e. | Excel Worksheet Functions | |||
Linear Mode
