How to change a column to numeric in Excel?

How to change a column to numeric in Excel?

When you open an Excel spreadsheet, by default the columns are indexed by letters. However if you'd like to change the format and have the index in numbers, follow the step-by-step guide below.

How to change Excel column index from letter to number?

  • Open your spreadsheet.
  • Click on the orb button.
  • Click on Excel Options and move to the Formula tab.
  • Go to the Working with formulas section.
  • Check the R1C1 reference style. Note : Upon hovering your mouse cursor on it, you shall get all the information about this feature.
  • Click on OK.
excel column index to numeric
© Copyright free
Do you need more help with Excel? Check out our forum!
Subject Replies
How to calculate positions (1st,2nd,3rd...) in Excel 6
Convert number to spelling 28
Unable to change date format in Excel 39
Excel - IF function with multiple words 14
Copying data from one Excel sheet to another. 30
Comparing two columns of names in Excel 8
How to convert number into text in Excel 9
Date formatting in dd/mm/yyyy 11
If a cell contains any text then add a value 20
Removing " false" value in "IF" 10
Around the same subject

Excel