Columname is a number
 

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

Columname is a number
 

Hi Ed,

ToolsOptionsGeneral tab, uncheck R1C1 Reference style

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Ed" wrote in message ...
| 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

Columname is a number
 

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

"Ed" wrote:

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