Column Header - Convert a Number to a letter

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.
 
S

stickandrock

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

Column letter to index 4
Creating sequential numbers plus a letter 4
Column header format 5
Column Header is not in Letter 1
How: reset the column headings from numeric to alphabetic? 1
Excel Convert word into numbers and back 4
Sum based on column and row criteria 4
Concatenation 5

Top