How do I change the column ID in Excel from number to text?

[Johnboy]

Currently my column labels in spreadsheets are not showing as text i.e. a,b,c
etc but as 1,2,3 .....

How do I change??

 

[Mike H]

Try,

Tools|options|general and un-check R1C1

Mike

 

[Johnboy]

Try,

Tools|options|general and un-check R1C1

 

[Mike H]

Johnboy,

I haven't git 2007 but I'd still bet that what's wrong. Search your help for
R1C1.

Mike

 

[Johnboy]

Johnboy,

I haven't git 2007 but I'd still bet that what's wrong. Search your help for
R1C1.

Mike

Thanks Mike that worked

 

[Mike H]

Your welcome and thanks for the feedback.

Mike

Thanks Mike that worked