Excel Display Problem???

  • Thread starter Michael Kintner
  • Start date
M

Michael Kintner

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
 
B

Bob Phillips

Mike,

Go into Tools>Options 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)
 
M

Michael Kintner

The formula checkbox is not set.

Bob Phillips said:
Mike,

Go into Tools>Options 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)
Click to expand...
 
G

Gord Dibben

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 Edit>Replace

What: =
With: =

Replace All.

Gord Dibben Excel MVP
 
Top