Can you convert Excel column indicators from Alpha to Numberic?

J

JudyB

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 [email protected]
 
B

Bob Phillips

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)
 
Top