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

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

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

hi
would be nice if we knew what version excel you are using.
2003
on the menu bartoolsoptionsgeneral tabuncheck R1C1 reference.
2007
Office buttonExcel optionsformulasuncheck R1C1 reference

regards
FSt1


"Marco" wrote:

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

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

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).
--
Thanx in advance,
Best Regards,

Faraz


"Marco" wrote:

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