+ Reply to Thread
Results 1 to 3 of 3

change column name from letters to numbers?

  1. #1
    Jerry
    Guest

    change column name from letters to numbers?

    I'm importing a 3rd party CSV file into Excel and then comparing some of
    the contents to a printed spec. Each numbered field in the spec
    corresponds to a column in the work sheet. I'd like to change the column
    headers from letters to numbers. Is that possible?

  2. #2
    Anne Troy
    Guest

    Re: change column name from letters to numbers?

    Tools-->Options, General tab. Check the R1C1 Reference Style.
    *******************
    ~Anne Troy

    www.OfficeArticles.com
    www.MyExpertsOnline.com


    "Jerry" <jerry@nowhere.com> wrote in message
    news:OoyPef$eFHA.3048@TK2MSFTNGP12.phx.gbl...
    > I'm importing a 3rd party CSV file into Excel and then comparing some of
    > the contents to a printed spec. Each numbered field in the spec
    > corresponds to a column in the work sheet. I'd like to change the column
    > headers from letters to numbers. Is that possible?




  3. #3
    Jerry
    Guest

    Re: change column name from letters to numbers?

    Thanks Anne.

    --
    Jerry

    Anne Troy wrote:
    > Tools-->Options, General tab. Check the R1C1 Reference Style.
    > *******************
    > ~Anne Troy
    >
    > www.OfficeArticles.com
    > www.MyExpertsOnline.com
    >
    >
    > "Jerry" <jerry@nowhere.com> wrote in message
    > news:OoyPef$eFHA.3048@TK2MSFTNGP12.phx.gbl...
    >
    >>I'm importing a 3rd party CSV file into Excel and then comparing some of
    >>the contents to a printed spec. Each numbered field in the spec
    >>corresponds to a column in the work sheet. I'd like to change the column
    >>headers from letters to numbers. Is that possible?


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1