Home |
Search |
Today's Posts |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hmm,
one problem with encoding is to obscure the value, so guessing the real value isn't easy and nonetheless make it siple for YOU to read the real value. Just using A to I for 1 to 9 makes decoding for others easier than necessary. How about using 0 = Z(ero) 1 = O(ne) 2 = T(wo) 3 = (th)R(ee) 4 = F(our) 5 = (fi)V(e) 6 = (si)X 7 = S(even) 8 = E(ight) 9 = N(ine) I would probably leave one number as a number (3) and use A for 8. e.g. 832.05 = A3T.ZV 96.74 = NX.SF Helmut. "Amin" schrieb im Newsbeitrag ... 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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Converting #s to specified #digits | Excel Discussion (Misc queries) | |||
Converting Dates to 8 digits | Excel Worksheet Functions | |||
Trying to truncate or separate the first 3 characters/digits of co | Excel Discussion (Misc queries) | |||
Converting special characters | Excel Discussion (Misc queries) | |||
Converting characters to numbers | Excel Worksheet Functions |