Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello Experts,
(I've previously asked this question but didnt get any replies.) At my shop I'm printing product labels from an Excel sheet. I'd like to add the cost field to the label but that would allow everyone to figure my cost for the item. So I thought of encoding the cost filed as the following: 0 = Z 1 = A 2 = B 3 = C .. .. 9 = I So if the cost in a cell is (322.40) it would translate to (CBB.DZ). Any ideas? Thanks in advance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Convert Letter to Number | Excel Worksheet Functions | |||
Convert a letter to a number | Excel Discussion (Misc queries) | |||
convert column number to letter | Excel Programming | |||
convert column number to letter | Excel Programming | |||
How do I convert a given number into a letter? | Excel Worksheet Functions |