cells will not calculate

J

jch2005

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

= 9 + 2

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

MUCH TIA,
 
N

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Select a range not equal to: 4
Calculate After hours 3
using the =page! feature to transpose a row to column 0
Ignoring Blank cells in 'IF' formula 2
Calculate focal length from FOV on cameras 0
Sum formulas 3
Error: Value in Formula of wrong data type 0
Adding dates in columns 2

Top