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

Mail Merge Directory Conditional Page Break 0
Keep First Letters, with exceptions 0
Improving Macro That Keeps First Letter 0
Section and Page numbering 0
Consolidation Table from Different Excel Tabs with Different Format 1
Creating a Chart on form from selected data in query. 0
Column Header 0
Random table of data - need to find every cell that contains specific data 1

Top