Ok, here's what I'm trying to accomplish. I would certainly appreciate any help anyone could give. Please try and frame any response with the idea that you're talking to someone with only a basic knowledge of excel.

I have a set of codes (00055, 00077x, etc.) that I need to enter into a spreadsheet. What I would like to happen when I enter them is for them to convert to a particular number. For example, I would like 00055 to represent $14.87. When someone enters in that code on a line, is it possible for it to automatically convert to that dollar amount? I have probably 400 codes, so the easiest, least time consuming way would be ideal.

Thanks in advance!