Column Header - Convert a Number to a letter

  • Thread starter Thread starter stickandrock
  • Start date Start date
S

stickandrock

I have extract some data from a website and my output file displays a column
in a number value instead of the normal Alphabetic value

Is there an option or piece of code that will convert the column headers to
letters verses the numbers.
 
Found the solution...

Goto Tools>Options>General tab

Uncheck: R1C1 reference style
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Showing Letters For Column Headers Rather Thann Numbers ? 1
Excel sheet with numbers as column & row headers - How? 3
Column header format 5
Creating sequential numbers plus a letter 4
column headers 2
why are my column headers numbers instead of letters? 2
Column Header is not in Letter 1
Change Excel column headers from numbers to letters 1

Back
Top