formula instead of result

S

scottymelloty

Right click and format the cell as general, then u have to retype th
formula back i
 
G

Gord Dibben

No need to re-type.

Change format to General then hit F2 then <ENTER>

Gord Dibben Excel MVP
 
M

Myrna Larson

And, if there a lot of them, Edit/Replace, Find what equal sign, Replace with
equal sign.
 
R

RagDyer

AND ... shortcut to format to General, you can use:
<Ctrl> <Shift> <~>
Then
<F2>
Then
<Enter>

--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"Gord Dibben" <gorddibbATshawDOTca> wrote in message
No need to re-type.

Change format to General then hit F2 then <ENTER>

Gord Dibben Excel MVP
 
Top