Hiding formulas

  • Thread starter Thread starter ps139
  • Start date Start date
P

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?
 
Select the range to fix.
Format|cells|number tab|choose General (or anything but text)
then
edit|replace
what: = (equal sign)
with: =
replace all
 
Works great (I don't know why) - but thanks!

Dave Peterson said:
Select the range to fix.
Format|cells|number tab|choose General (or anything but text)
then
edit|replace
what: = (equal sign)
with: =
replace all
Click to expand...
 
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.
 
Back
Top