View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Justin Steiner Justin Steiner is offline
external usenet poster
 
Posts: 1
Default Cost Coding? How in the.....?

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.