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

  • Thread starter Thread starter Kajsa
  • Start date Start date
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 :-)
 
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!
 
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!!
 
Back
Top