The reason is that you have enabled the R1C1 style referencing,
rather than the A1 style. To change this, go to the Tools menu,
choose Options, then the General tab. There, uncheck "R1C1
reference style".
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
message
news:
[email protected]...