This post will guide you how to change column letter to number in your current worksheet in Excel. How to set the column letters in numbers in Excel 2013/2016.

Showing Column Letter to Number

If you want to change the column letters to numbers in Excel, you can do the following steps:

Step1: click the File tab, and select Excel Options menu, and the Excel Options dialog will open.

Step2: click Formulas from the left pane in Excel Options dialog box, and scroll to Working with formulas section, and check the R1C1 reference style checkbox. And click Ok button.

Step3: you would see that the column letters have been shown as numbers.

Note: If you want to show column numbers to letters, just uncheck the R1C1 reference style option.