Column header changed to numbers, how do I change to letters?

L

LM

On my spreadsheet (version 2003) the column header has changed to numbers.
Does anyone know how to change it back to letters?
 
B

BonnieR

I need the answer to this same question, on a file I created in Office 2003
at work and brought home to my home computer which is Vista and Office for
Vista (not sure what the year is...maybe 2007?) It's a Dell computer.
 
N

Niek Otten

If it is Excel 2007:

Office button (Large round button top left)>Excel options>Formulas
tab>Working with formulas>Uncheck R1C1 Reference style
If not Excel 2007: I gave you the answer already
 

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 Labels 1
The column names (A,B,C, etc...) changed to numbers?????????? 1
change column headings letters 5
How do I change my column headers? 1
excel colums and rows 1
Showing Letters For Column Headers Rather Thann Numbers ? 1
Column headings 2
Excel 2007... fix column headings from numbers back to letters 4

Top