Help with Excel

[nick_taira1]

With my job I need to type what seems like random numbers such as "3H23563" and I want to be able to write all my random numbers and have them automatically convert to a dollar figure. For example: 3H23563 would equal $15.25 in a different column when I type that random number into excel.
--3H23563 would be the billing code and $15.25 would be the cost of the billing-- Any help would be GREAT!

 

[Mohammad Basem]

You may post your workbook so we can work on it rather than by example.