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