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

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

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

Correct the formula checkbox is not set.


"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

Michael

Sounds like the cell is formatted as Text.

Clear the contents and Format to General.

Re-type the formula.

If you have a whole whack of these, select all and EditReplace

What: =
With: =

Replace All.

Gord Dibben Excel MVP


On Mon, 5 Jan 2004 13:44:11 -0500, "Michael Kintner"
wrote:

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

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