View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Dana DeLouis Dana DeLouis is offline
external usenet poster
 
Posts: 947
Default 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!!!!