Change Excel Column name from A,B,C.. to 1,2,3..

If you want to change  microsoft excel column A, B, C, D …  to 1, 2, 3, 4, ….then follow the following procedure.

This Procedure is different in In Office 97-2003 and in Office 2007.

In Office 2003, go to Tools -> Options.

Click on the General Tab.

Under the settings, Check or uncheck R1C1 reference style to use it or to change it to A1 reference style.

In Office 2007, Click the Office button and click Excel Options which you will find at the end near Exit Excel.

Go to Formulas tab and under Working with formulas, Check or uncheck R1C1 reference style to use it or to change it to A1 reference style.