Columname is a number

[Ed]

Hi,
I have a columnumber in sted of a letter in my Excel. How can I change this
back to letters
so the top line is 1,2,3,4,5,6,
and not a,b,c,d,e

 

[Niek Otten]

Hi Ed,

Tools>Options>General tab, uncheck R1C1 Reference style

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Hi,
| I have a columnumber in sted of a letter in my Excel. How can I change this
| back to letters
| so the top line is 1,2,3,4,5,6,
| and not a,b,c,d,e
| --
| kind regards
|
| Ed

 

[Anu]

Go to Tools, Options,General,and Uncheck the R1C1 reference style