 |
 |
|
|
|
|
Welcome to the { mindfrost82.com } forums. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please contact contact us. |
|
|||||||
 |
|
|
LinkBack | Thread Tools | Search this Thread | Display Modes |
07-08-2008, 06:00 PM
|
|||
|
|||
|
Excel 2007: Column Reference changed from Alpha to Numeric, ?
A Workbook I've been resaving as different versions recently changed
it's column references to numbers instead of letters. So, B=2, AA=27, etc. Also, when I build forumlas the reference for a cell is it's row x cell, each of which as position X & Y coordinates. There are some copy/paste issue with formulas, which may or may not be related. 
|
|
07-09-2008, 02:29 AM
|
|||
|
|||
|
Re: Excel 2007: Column Reference changed from Alpha to Numeric, ?
Tools / Options... General tab, UNcheck "R1C1 reference style"
HTH, Bernie MS Excel MVP <arlon.keegan@gmail.com> wrote in message news:322a2cd6-0bf7-4e88-848d-8c0c224dbe0a@m3g2000hsc.googlegroups.com... >A Workbook I've been resaving as different versions recently changed > it's column references to numbers instead of letters. So, B=2, AA=27, > etc. Also, when I build forumlas the reference for a cell is it's row > x cell, each of which as position X & Y coordinates. There are some > copy/paste issue with formulas, which may or may not be related.
|
|
07-09-2008, 02:41 AM
|
|||
|
|||
|
Re: Excel 2007: Column Reference changed from Alpha to Numeric, ?
In xl2007, it's somewhere under the Office button|Excel Options.
Bernie Deitrick wrote: > > Tools / Options... General tab, UNcheck "R1C1 reference style" > > HTH, > Bernie > MS Excel MVP > > <arlon.keegan@gmail.com> wrote in message > news:322a2cd6-0bf7-4e88-848d-8c0c224dbe0a@m3g2000hsc.googlegroups.com... > >A Workbook I've been resaving as different versions recently changed > > it's column references to numbers instead of letters. So, B=2, AA=27, > > etc. Also, when I build forumlas the reference for a cell is it's row > > x cell, each of which as position X & Y coordinates. There are some > > copy/paste issue with formulas, which may or may not be related. -- Dave Peterson
|
|
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
