ExcelBanter - convert columns from numbers to a lettering system

ExcelBanter (https://www.excelbanter.com/)

- New Users to Excel (https://www.excelbanter.com/new-users-excel/)

- - convert columns from numbers to a lettering system (https://www.excelbanter.com/new-users-excel/234878-convert-columns-numbers-lettering-system.html)

johnmonek

convert columns from numbers to a lettering system

How do I convert columns that are numbered into letters ?

Bernard Liengme[_3_]

convert columns from numbers to a lettering system

If you are speaking of column headers then open the Excel options and
uncheck "Use R1C1 referencing"
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"johnmonek" wrote in message
...
How do I convert columns that are numbered into letters ?

All times are GMT +1. The time now is 09:46 PM.