ExcelBanter - HOW DO I CHANGE COLUMNS FROM NUMERIC TO ALPHA HEADINGS?

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

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - HOW DO I CHANGE COLUMNS FROM NUMERIC TO ALPHA HEADINGS? (https://www.excelbanter.com/excel-discussion-misc-queries/40844-how-do-i-change-columns-numeric-alpha-headings.html)

Barry

HOW DO I CHANGE COLUMNS FROM NUMERIC TO ALPHA HEADINGS?

somehow a user on site has changed them from alpha to numeric, I'd like to
change them back but can't see how!

Gary's Student

Tools Options General
Clear the R1C1 check box
--
Gary's Student

"Barry" wrote:

somehow a user on site has changed them from alpha to numeric, I'd like to
change them back but can't see how!

All times are GMT +1. The time now is 01:31 PM.