View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Dave O
 
Posts: n/a
Default Format text to numbers

A standard way to convert text to a number is, for example:
=CODE("A") which returns the ASCII code number for this character, 65

You can convert an ASCII number to text like this:
=ASC(65) which returns A

You can find an ASCII table he
http://www.neurophys.wisc.edu/www/comp/docs/ascii.html

Does this help? Please post a working example.