How do I change my column designator from Numeric to Alpha?

J

Jon

I have been using Excell for several years, but have never experienced my
recent quandry. My column which are normally designated by alpha characters
,"A, B, C..." are now being designated as numeric, "1, 2, 3..." Can someone
help to change them back?
 
D

Dave Peterson

In xl2003 menus, it's:
Tools|Options|General Tab|Uncheck R1C1 Reference style

Excel picks up this setting from the first workbook you open in that session.
 

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 column addresses from numeric to alpha? 1
Excel XP. column headings are numeric I want alpha 1
how do I return my alpha-numeric keypad to numbers 1
Worksheet has numeric column headings. Change to alpha headings? 1
How can I change column headers from numeric to alpha? 2
change alpha to numeric 12
how do I column heading to alpha from Numeric? 1
Alpha column lables 2

Top