Formula is changed to a constant

[Guest]

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!

 

[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

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!

 

[DavidObeid]

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

Regards,

David Obei

 

[Trevor Shuttleworth]

David

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

Regards

Trevor

 

[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

 

[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.

 

[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

 

[DavidObeid]

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