How do I convert letters to numbers in Excel?
A=0
Hi. Note that the Asc Code for the letter A is =CODE("A"), or 65.
If A1 has the letter "A", then one way...
=CODE(A1)-65
...e.tc.
--
HTH :)
Dana DeLouis
Windows XP & Excel 2007
"scarly123" wrote in message
...
I want to convert letters to numbers in Excel such where A=0 , B=1,
C=2,....and on. Help please!!!!
|