| Home |
| Search |
| Today's Posts |
|
#1
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
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
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
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
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula changed to value | Excel Discussion (Misc queries) | |||
| Format changed when the details in cell changed | Excel Worksheet Functions | |||
| update formula in column when another cell formula is changed | Excel Worksheet Functions | |||
| Formula being changed | Excel Discussion (Misc queries) | |||
| Column reference got changed | New Users to Excel | |||
Linear Mode
