How do I change headings (column name) from numbers to letters?

F

FSt1

hi
would be nice if we knew what version excel you are using.
2003
on the menu bar>tools>options>general tab>uncheck R1C1 reference.
2007
Office button>Excel options>formulas>uncheck R1C1 reference

regards
FSt1
 
F

Faraz A. Qureshi

Use
=Text(A1,"0")
to convert the number to text and copy (Ctrl+C) and paste the values (Alt,
E, S, V, Enter).

"0" in the formula represents a single digit for the same purpose.
"000" would convert 1 to 001 (But in text).
 

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

Excel 2007... fix column headings from numbers back to letters 4
column headings 3
Column Heading 1
Changing grey column headings from numbers back to capital letters 2
Column Headings 1
Column headings - urgent help needed please 3
How do I change my column headings from numbers to alpha 2
Excel - Column headings 1

Top