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

M

Martin

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

Guest

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)
 
J

JulieD

Hi Martin

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

Cheers
JulieD
 
Top