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