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

On Dec 18, 4:17*pm, James Irwin
wrote:
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.