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?

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

> 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
---