View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Scoops Scoops is offline
external usenet poster
 
Posts: 108
Default How do I convert letters to numbers in Excel?

On 18 May, 21:50, scarly123
wrote:
I want to convert letters to numbers in Excel such where A=0 , B=1,
C=2,....and on. Help please!!!!


Hi scarly123

If A is in A1 then in B1 type

=CODE(A1)-65

Regards

Steve