Thread: How do I change the column ID in Excel from number to text?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Mike H Mike H is offline
external usenet poster
  
Posts: 11,501
Default How do I change the column ID in Excel from number to text?
Try,

Tools|options|general and un-check R1C1

Mike

"Johnboy" wrote:

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??
Reply With QuoteReply With Quote