Converting digits to characters (123 to ABC)
How about using numbers:
reverse the numbers and drop the decimal
cost is 322.04 the field would show 40223
cost is 569.38 the field would show 83965
cost is 256.02 the field would show 20652
or use a decimal out of place with reversed numbers
(decimal moved 2 places)
cost is 322.04 the field would show 4022.3
cost is 569.38 the field would show 8396.5
cost is 256.02 the field would show 2065.2
HTH,
--
Data Hog
"Amin" wrote:
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
|