Hiding formulas

[ps139]

Sometimes when I enter a formula into a cell, the formula shows instead of
the result. I can often fix this by clicking in the contents bar and
clicking enter (or just hit F2 and enter), but I have several thousand cells
that I need to fix in this way. Is there a better method?

 

[Dave Peterson]

Select the range to fix.
Format|cells|number tab|choose General (or anything but text)
then
edit|replace
what: = (equal sign)
with: =
replace all

 

[ps139]

Works great (I don't know why) - but thanks!

Select the range to fix.
Format|cells|number tab|choose General (or anything but text)
then
edit|replace
what: = (equal sign)
with: =
replace all

 

[Dave Peterson]

It's just like typing a new formula into a cell that's formatted as General.
Excel will see the formula and know that it has to evaluate it.