ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Can you convert Excel column indicators from Alpha to Numberic? (https://www.excelbanter.com/excel-discussion-misc-queries/69038-can-you-convert-excel-column-indicators-alpha-numberic.html)

JudyB

Can you convert Excel column indicators from Alpha to Numberic?
 
Does anyone know how to convert the column indicators (for example A, B, C .
.. ) from alpha to numeric indicators (1, 2, 3 . . . .)

Please email back to

Bob Phillips

Can you convert Excel column indicators from Alpha to Numberic?
 
Be aware that if you do this, you have to enter fromulae in R1C1 style.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Gary''s Student" wrote in message
...
Tools Options... General and check R1C1
--
Gary's Student


"JudyB" wrote:

Does anyone know how to convert the column indicators (for example A, B,

C .
. ) from alpha to numeric indicators (1, 2, 3 . . . .)

Please email back to





All times are GMT +1. The time now is 04:55 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com