| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I change headings (column name) from numbers to letters?
Suddenly my headings are numbers instead of letters. I want to use letters.
|
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I change column headings fron numbers to letters in excell. | New Users to Excel | |||
| Change worksheet column headings from numbers to letters | Excel Discussion (Misc queries) | |||
| how do i change the column headings from numbers to letters | Excel Discussion (Misc queries) | |||
| nedd to change column headings from numbers back to letters | New Users to Excel | |||
| how do i change the column headings from numbers to letters in ex | Excel Discussion (Misc queries) | |||
Linear Mode
