View Single Post
  #4   Report Post  
Old January 1st 21, 01:16 PM
Tim Paine Tim Paine is offline
Junior Member
 
First recorded activity by ExcelBanter: Dec 2020
Posts: 27
Default

Follow these steps to change column from numeric to alphabet

Clear the R1C1 reference style selection in Excel preferences.
Difference between A1 and R1C1 reference styles

On the Excel menu, click Preferences.

Under Authoring, click General

Clear the Use R1C1 reference style check box.

The column headings now show A, B, and C, instead of 1, 2, 3, and so on.

I hope this is helpful!
Tim Paine