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

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 :-)
--
Kajsa

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

Excel 2003:-
ToolsOptionsGeneralUncheck the R1C1 Reference Style checkbox and give ok

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

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"Kajsa" wrote:

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 :-)
--
Kajsa

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

A very grateful THANK YOU!!! So easy when you know it :-)
--
Kajsa


"Ms-Exl-Learner" skrev:

Excel 2003:-
ToolsOptionsGeneralUncheck the R1C1 Reference Style checkbox and give ok

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

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"Kajsa" wrote:

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 :-)
--
Kajsa

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

You are welcome!

--------------------
(Ms-Exl-Learner)
--------------------


"Kajsa" wrote:

A very grateful THANK YOU!!! So easy when you know it :-)
--
Kajsa


"Ms-Exl-Learner" skrev:

Excel 2003:-
ToolsOptionsGeneralUncheck the R1C1 Reference Style checkbox and give ok

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

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"Kajsa" wrote:

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 :-)
--
Kajsa

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

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

"Kajsa" wrote:

A very grateful THANK YOU!!! So easy when you know it :-)
--
Kajsa


"Ms-Exl-Learner" skrev:

Excel 2003:-
ToolsOptionsGeneralUncheck the R1C1 Reference Style checkbox and give ok

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

Remember to Click Yes, if this post helps!

--------------------
(Ms-Exl-Learner)
--------------------


"Kajsa" wrote:

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 :-)
--
Kajsa