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?