Excel Display Problem???

  • Thread starter Thread starter Michael Kintner
  • Start date 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
 
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)
 
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...
 
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
 
Back
Top