Excel 2007: Column Reference changed from Alpha to Numeric, ?

[arlon.keegan]

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.

 

[Bernie Deitrick]

Tools / Options... General tab, UNcheck "R1C1 reference style"

HTH,
Bernie
MS Excel MVP

 

[Dave Peterson]

In xl2007, it's somewhere under the Office button|Excel Options.