How to change columns from numbers to letters

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: How to change columns from numbers to letters

  1. #1
    New Member
    Join Date
    Mar 2012
    Posts
    28
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default How to change columns from numbers to letters

     
    Hi folks

    I think this will be an easy one for you clever people. I have had this before and for the life of me cant work how to change the columns

    I have a spreadsheet that has columns A,B,C, etc that are now appearing as 1,2,3 - I want them to be letters and cant work out how to change them back.

    thanks in advance

  2. #2
    Board Regular Weazel's Avatar
    Join Date
    Dec 2011
    Location
    Florida
    Posts
    3,081
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How to change columns from numbers to letters

    could be you have the R1C1 reference style option turned on...
    depending on the version of excel you are using you can check under options and see if it is checked.

    In excel 2010 its under options, formulas.

  3. #3
    MrExcel MVP VoG's Avatar
    Join Date
    Jun 2002
    Location
    127.0.0.1
    Posts
    63,651
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)

    Default Re: How to change columns from numbers to letters

    HTH, Peter
    Please test any code on a copy of your workbook.

  4. #4
    MrExcel MVP
    Moderator
    Peter_SSs's Avatar
    Join Date
    May 2005
    Location
    Macksville, Australia
    Posts
    35,581
    Post Thanks / Like
    Mentioned
    23 Post(s)
    Tagged
    1 Thread(s)

    Default Re: How to change columns from numbers to letters

      
    Take a look here.
    Hope this helps, good luck.
    Peter
    Excel 365 + Excel 2010, 2007 - Windows 10, 7
    - Want to help your helpers by posting a small, copyable, screen shot directly in your post? Look here
    - If posting vba code, please use Code Tags - like this [code]Paste code here[/code] - or use the VBHTML Maker
    - Read: Forum Rules & Forum Use Guidelines

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com