In Excel the colums which used to be A,B,C D etc are now 1,2,3
 

Why is this, and how can I change it back to A,B,C etc

In Excel the colums which used to be A,B,C D etc are now 1,2,3
 

Tools Options, on the General tab uncheck R1C1 reference style.

"Dave Lock" wrote:

Why is this, and how can I change it back to A,B,C etc

In Excel the colums which used to be A,B,C D etc are now 1,2,3
 

Go to menu: ToolsOptionsGeneral Uncheck "R1C1 Reference Style"

--
Best regards,
---
Yongjun CHEN
Vice President, CAPST
=================================
XLDataSoft - Data Analysis Expert, Excel/VBA Specialist
- - - - www.XLDataSoft.com - - - -
Free Excel-Based Data Processing Tool is Available for Download
Free Excel / VBA Training Materials is Available for Download
=================================
"Dave Lock" <Dave wrote in message
...
Why is this, and how can I change it back to A,B,C etc

In Excel the colums which used to be A,B,C D etc are now 1,2,3
 

"Dave Lock" <Dave wrote in message
...
Why is this, and how can I change it back to A,B,C etc

Tools/ Options/ General
Unset "R1C1 reference style"
--
David Biddulph