lettered columns changed to numbers

G

Guest

Somehow the columns labeled with letters changed to numbers. How do I get
them switched back?
 
P

(PeteCresswell)

Per kdsteff:
Somehow the columns labeled with letters changed to numbers. How do I get
them switched back?
Click to expand...

Tools|Options|General|R1C1 Reference Style (un-check the box)
 
S

Sandy Mann

Tools > Options > General then Uncheck R1C1 reference style

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

(e-mail address removed)
Replace @mailinator.com with @tiscali.co.uk
 

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 you make the labels of the columns back to letters from numbers? 1
How to change numbered columns to letters? 3
Columns now numbers rather than letters how do i get letters back 2
Column labels showing as 1 2 3 4 5 instead of A B C D E - how to f 3
Printing SQL query results in a list of columns, instead of one long column 1
Headers with numbers in front of them and table of contents 2
Excel 2007 paste data, need to convert to numbers 3
Columns have changed from letters to numbers 4

Top