|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
December 23rd, 2009, 12:09 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
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 
|
|
#2
December 23rd, 2009, 12:17 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
|
|
#3
December 23rd, 2009, 12:36 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
|
|
#4
December 23rd, 2009, 02:49 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
|
|
#5
December 23rd, 2009, 03:37 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
