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!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formulas in Excel using [R-1] not A10 references 2
How to change =SUM(R[-56]C:r[-1]c) to =SUM(D1:D2) 2
Stop cell reference in formula changing when insert column? 1
How to prevent any changes made to formulas from moving reference cells? 9
Excel change SUM references if you cut & paste the first cell in SUM... 5
Refer to a defined name in a formula 3
OR in SUMPRODUCT formula 3
INT((MONTH($C$1:$C$7)+2)/3)=$A$2 2

Back
Top