Excel displaying formulae as constant and not calculating formula
 

When entering a formula directly into a cell (starting with =) the formula
does not calculate, rather the formula is displayed in the cell as if it were
just text. The only way I have managed to get the formula to calculate is to
make a mistake in the formula and let the 'There is an error in the formula
you typed, do you want to accept the correction' dialog correct the formula.

Can anyone explain how to fix this?

Excel displaying formulae as constant and not calculating formula
 

2 thoughts
1) the cells are not formated to text and so not performing
calculations
2) you have automatic calculation turned on in your options


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=513072

Excel displaying formulae as constant and not calculating formula
 

2) you have automatic calculation turned on in your options

Think Dav meant:
2) you *do not* have automatic calculation turned on in your options

To quickly check/ensure that calc mode is set to auto, via:
Click Tools Options Calculation tab Check "Automatic" OK
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---