The reference in the formula has changed to eg =R[-1]C/R[-237]C

K

Kajsa

I don´t know how it has happened, but I want to read the formula as eg
=sum(A2/Z18)

Old documents are shown like this and my new ones come out like this too.

Help, anyone out there?!
Merry X-mas from Sweden :)
 
M

Ms-Exl-Learner

Excel 2003:-
Tools>>Options>>General>>Uncheck the R1C1 Reference Style checkbox and give ok

Excel 2007:-
Click the Office Ribbon Button (colorful round circle at the top Left
corner)>Excel Options>Formulas>>Working With Formulas>> Uncheck the R1C1
Reference Style checkbox and give ok.

Remember to Click Yes, if this post helps!
 
J

JLatham

LOL! Everything is easy "if you know it" ... problem is none of us know it
all, thus we have support forums. Next problem... remembering it!!
 
Top