ExcelBanter - How can I change my column references from Alpha to Numeric?

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How can I change my column references from Alpha to Numeric? (https://www.excelbanter.com/excel-worksheet-functions/105097-how-can-i-change-my-column-references-alpha-numeric.html)

Danelle Boling, Sales Analyst

How can I change my column references from Alpha to Numeric?

PCLIVE

How can I change my column references from Alpha to Numeric?

Click Tools and go to Options.
On the General tab, select 'R1C1 reference style' under Settings.

"Danelle Boling, Sales Analyst"
om wrote in message
...

All times are GMT +1. The time now is 08:16 AM.