#1
|
|||
|
|||
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) |
#2
|
||||
|
||||
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, |
#3
|
|||
|
|||
Thank you.
|
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 |
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 |