cells show formula like in formula bar, rather than result of form

[James Irwin]

hi - i must have hit a setting somehow as all new formulae i enter into
excel, do not return the result of the formulae - they just return the
formulae itself (e.g. =e1). Existing formulae are not displayed so it's not a
ctrl + ` issue! any help appreciated.

 

[Pete_UK]

Perhaps the cells with the new formulae in are formatted as Text.
Format them as General, then F2 followed by <Enter> to bring about the
change in format.

Hope this helps.

Pete

 

[Dave Peterson]

It sounds like the cells have been formatted as text.

Select the offending range
format|cells|Number tab|general (or anything but text)
and reenter the formula.

Or

You could be looking at formulas.
In xl2003:
Tools|Options|view tab|uncheck formulas