Another possibility

format the cell as General rather than text

--
Regards,
Tom Ogilvy
"Michael Kintner" wrote in message
...
The formula checkbox is not set.

"Bob Phillips" wrote in message
...
Mike,

Go into ToolsOptions and on the View tab, see if the Formulas checkbox
is
set. If so, unset it.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"Michael Kintner" wrote in message
...
For some reason my cell keeps displaying the formula. If I clear all
contents it works fine. But as soon as I enter another formula it
shows
the
formula again.

Any ideas why? And how to fix this?

Thanks in advance for any help!!!

Mike