Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,203
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Formula changed to value Metro Excel Discussion (Misc queries) 0 April 14th 09 06:04 PM
Format changed when the details in cell changed angel Excel Worksheet Functions 9 July 15th 08 12:36 AM
update formula in column when another cell formula is changed Susanelm Excel Worksheet Functions 1 June 9th 08 05:06 PM
Formula being changed David Klassen Excel Discussion (Misc queries) 4 May 18th 06 04:47 PM
Column reference got changed willy New Users to Excel 2 July 8th 05 10:12 AM


All times are GMT +1. The time now is 10:26 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"