columns showing numbers instead of alphabets

G

Guest

Hi all. In my excel sheet, all the columns are showing numbers instead of
alphabets, eg 1,2,3... instead of A,B,C... Why is this so? How can i change
them back to show alphabets? Thks in advance.
 
G

Guest

Try this:

From the Excel main menu:
<tools><options><general tab>
UNcheck: R1C1 Reference style

Does that help?
***********
Regards,
Ron

XL2002, WinXP
 

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 headings to numbers and row headings to alphabets? 2
My Column display as "numbers" instead of "alphabets" 1
how to mention rows in alphetical format instea dof numbers 2
Excel columns 1
Excel sheet column name change 2
Separate Text into numbers and alphabets 4
how to change the alphabets to numbers and numbers to alphabets in 2
data validation in excel user form 2

Top