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

  • Thread starter Thread starter arlon.keegan
  • Start date Start date
A

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.
 
Tools / Options... General tab, UNcheck "R1C1 reference style"

HTH,
Bernie
MS Excel MVP
 
Back
Top