Formula is changed to a constant

T

Terry Moore

I changed a reference in a formula from relative to absolute using the F4 key. Now Excel thinks that cell is a constant and prints the forumula, including the equals sign, but does NOT compute the formula. This is infuriating!
 
T

Trevor Shuttleworth

Terry

not quite sure how you did this. F2 followed by F9 would convert a formula
to a value.

Perhaps you pressed F2 and then F9 instead of F4 ?

Just a thought; can't reproduce it any other way.

Regards

Trevor


Terry Moore said:
I changed a reference in a formula from relative to absolute using the F4
Click to expand...
key. Now Excel thinks that cell is a constant and prints the forumula,
including the equals sign, but does NOT compute the formula. This is
infuriating!
 
D

DavidObeid

In Tools/Options select the View tab, under the Windows options headin
uncheck the Formulas box.

Regards,

David Obei
 
T

Trevor Shuttleworth

David

that would relate to all formulae; but they would still be calculated.

Regards

Trevor
 
D

DavidObeid

Well then, it's got me beat (not hard since I am not an excel wizz).

Is there a way of converting formulae to values for a range of cells?

Pressing F2 then F9 only works on the top left cell in a range (or am
doing it wrong?)

Regards,

Dave
 
D

David McRitchie

Hi David,
Select your range of cells
Ctrl+C to copy
Edit, Paste Special, Values

if you want to paste it somewhere else
choose the upper left cell for where you want to
paste to.
 
G

Gord Dibben

Dave

Easieat way to do multiple cells is to copy them all then Paste Special>Values
on top of themseleves.

Gord Dibben XL2002
 
D

DavidObeid

Thanks gents. Another excel skill I can thanks the people on this lis
for. This forum is awesome
 
Top