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

[Marco]

Suddenly my headings are numbers instead of letters. I want to use letters.

 

[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

 

[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).