Good point, you can also press Ctrl-` to toggle that feature.

--JP

On Jun 15, 10:15*am, "David Biddulph" <groups [at] biddulph.org.uk
wrote:
Firstly: Tools/ Options/ View and make sure that "Formulas" is not checked.

If that is OK, my guess is that you have the cell formatted as text. *Set
the cell format to General or Number, then re-enter the formula (either
retype, or F2 and enter).
--
David Biddulph