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



ps139 wrote:

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

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

"Dave Peterson" wrote:

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 wrote:

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

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.

ps139 wrote:

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

"Dave Peterson" wrote:

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 wrote:

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


--

Dave Peterson