This may be a double post as I'm not sure if my first replay made it through
or not.

As a test I took some sample data and used the 'Edit'...'Replace' to
replaced the specified number with the proper letter (and removed the .) and
in quite short order I had the proper codes where there used to be currency.

"Justin Steiner" wrote:

I work for a computer retailer and we track our product costs and markup
using excel. I need to find a way to convert the numeric value of our cost to
text using a cost-code. Our code is SOUTH PLACE, with each letter of the code
having a corresponding value 1-0. For example, something costing $129.95
would be coded as SOCCH.

As it is, I have to type the cost code for hundereds of products manually
nearly twice a month. If anyone could point me in the right direction, I'd
REALLY appreciate it.