View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Amin Amin is offline
external usenet poster
 
Posts: 48
Default Converting digits to characters (123 to ABC)

Hello Experts,

At my shop I'm printing product labels from an Excel sheet.

I'd like to add the cost field to the label but the problem everybody would
be able to know my cost for an item unless I encode it, so I thought of
converting numbers to characters for example:

0 = Z
1 = A
2 = B
3 = C
4 = D

So, if the cost of an Item is 322.04 the field would show CBB.ZD

Any thoughts?

Thanks in advance