Excel Column showing numeric

W

William Rulla

Question, I just installed Windows XP on my laptop. I
subsequently re-installed Microsoft Office 2000
professional. The problem I am facing is both the row and
column headers are numeric so I am unable to do any cell
calculations. How do I get the column heading back to
Alpha Characters instead of numerics?
 
N

Niek Otten

Tools>Options>General, uncheck R1C1 Reference style

BTW the R1C1 style works perfectly as well.
 

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

Worksheet has numeric column headings. Change to alpha headings? 1
Change the column designation from a numeric to an alpha 2
How do I change the Excel Column Labels as back to alpha? 1
Excel 2007 Numerical Column Headers 4
Numeric column headers Excel 2007 2
Excel Column Headings Numeric to Alpha 1
Alpha & Numeric Counts in Excel 3
Column Headings 3

Top