number column header

T

tgmsr

One day I launched my excel 2000 and was surprised to see
all column headers became numbers, 1, 2, 3, etc. instead
of normal alpha (A, B, C, etc)and they stay numeric even
opening previous excel files. Does anyone know how to put
headers back to alpha?
Thanks.
 
P

Paul B

Tools, options, general, uncheck R1C1 reference style

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 97 & 2000
** remove news from my email address to reply by email **
 

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

How do I change my column designator from Numeric to Alpha? 1
Column Headings 4
How do I change my column headers? 1
Hiding matrix headers 1
Grouping in one row 4
Add incremental character to cell value at change in value 449becomes 449-A 510 becomes 510-B 2
Sorting Alphanumeric data 6
Different Page Numbers or Number Formats for Different Sections 1

Top