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.