Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 03-30-2010, 08:28 PM
herbycanopy herbycanopy is offline changing column formats Windows XP changing column formats Office 2007
Novice
changing column formats
 
Join Date: Mar 2010
Posts: 9
herbycanopy is on a distinguished road
Default changing column formats


For some reason my Excel columns are not abc's now, they are now numbers. This makes cell referances look like this now..

Code:
=SUM(R[-4]C:R[-2]C)
How can I change this back to the old A1 B3 system?
Reply With Quote
  #2  
Old 03-30-2010, 09:05 PM
ConneXionLost's Avatar
ConneXionLost ConneXionLost is offline changing column formats Windows XP changing column formats Office 2003
Simulacrum
 
Join Date: Jan 2010
Location: Victoria, Canada
Posts: 86
ConneXionLost is on a distinguished road
Default

In Excel 2003, go to Tools -> Options.

Click on the General Tab.

Under the settings, Check or uncheck R1C1 reference style to use it or to change it to A1 reference style.

- - - - - - -

In Excel 2007, Click the Office button and click Excel Options which you will find at the end near Exit Excel.

Go to Formulas tab and under Working with formulas, Check or uncheck R1C1 reference style to use it or to change it to A1 reference style.

Cheers,
Reply With Quote
  #3  
Old 03-30-2010, 09:11 PM
herbycanopy herbycanopy is offline changing column formats Windows XP changing column formats Office 2007
Novice
changing column formats
 
Join Date: Mar 2010
Posts: 9
herbycanopy is on a distinguished road
Default

Thank you.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Inverting Data in a Column mrdave100 Word 0 03-08-2010 01:27 PM
changing font size without changing leading carolns Word 1 09-14-2009 12:30 PM
Lost Column header Policy Peddler Outlook 1 06-05-2009 07:57 AM
changing column formats Last Number in a Column paulrm906 Excel 1 12-05-2008 07:51 PM
Excel error: "Too many different cell formats" enviroko Excel 0 01-09-2008 07:27 AM


All times are GMT -7. The time now is 05:03 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2020, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2020 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft