How do I change Column Headings from Letters to Numbers in Excel .

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am sure it is easy to change the headers from the default A, B, C,.. to
numbers (1, 2, 3, ...). The book I have does not mention it and I have not
yet found it.
The reason I am after numbers, is I want to import a comma delimited file
daily. The file is almost 100 columns and when setting the 'Text', 'General',
or 'Skip This File' there is almost no way to keep track of which column is
being formatted ('cept the finger & toe method)
Am I going about this wrong? I would like to create a template for this.
Any help is appreciated.
 
hi,
goto tools>options>general
check R1C1 reference style. click ok.
this will change the column headers from letters to numbers
NOTE: this also changes your formulas.
from =(A1+B2) to =(R1C1+R1C2)
 
Hi Martin

does tools / options / general - R1C1 style give you what you're after?

Cheers
JulieD
 
You must log in or register to reply here.

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 2007... fix column headings from numbers back to letters 4
Changing grey column headings from numbers back to capital letters 2
How do columns headings change from letters to numbers? 5
Change worksheet column headings from numbers to letters 2
Columns now numbers rather than letters how do i get letters back 2
How do I change headings (column name) from numbers to letters? 2
Column Heading Error 3

Back
Top