Changing prices to letters

[vcsindy]

My boss wants to convert our price column to a letter code. as in $4.50 would be DEI
using this template:
S I M P L Y W O R K
1 2 3 4 5 6 7 8 9 0

where each number becomes a number in the words simply work.

Is there a way to create a formula or a macro the when the price is typed in a cell that it changes to the alphs code?

Thanks
Dan

[micope21]

Well to the forum

Will this help =LOOKUP(B2, {1,5,10,15,20,25,30,35,40}, {"AA","AC","BA","BD","CA","CC","DA","DD","EA",0})
Column A > put in $ then copy down
Column B2 > type in say 5
Column C2 > =LOOKUP(B2, {1,5,10,15,20,25,30,35,40}, {"AA","AC","BA","BD","CA","CC","DA","DD","EA",0}) You can change number and letter> Once done then copy down where you want to stop.
Result > $5 would be AC

Good Luck!

[vcsindy]

Actually column E will have the prices, and any price entered will need to be changed to te corresponding letter.

[jindon]

$4.50 would be DEI
using this template:
S I M P L Y W O R K
1 2 3 4 5 6 7 8 9 0

Can you explain why 450 would be "DEI"?
Isn't it "PLK"?

[vcsindy]

Sorry You're right...PLK. How would I isert this formula

[jindon]

This will covert only numbers to the correspoding letters, ignoring no numeric characters.
i.e.
12xyz45 becomes "IMLY"

Change any cell(s) in Col.E

To a WorkSheet module in question.

Please Login or Register  to view this content.

[vcsindy]

tHANK yOU SO MUCH....hOW DO i USE IT? dO i PASTE IT TO THE CELL?

[jindon]

It is not a function used in cell.

Try change any cell in Sheet1 Col.E in attached, you will see how it works.

[vcsindy]

Thank you thank you thank you!!! You are awesome

[vcsindy]

Is there anyway the 0 before the decimal can associate with the K so 450.00 will be LYK?

[jindon]

OOps

1) Right click on the Sheet1 sheet tab
2) select [View Code]

Then you will see the codes in the right pane.

Replace following one line

Please Login or Register  to view this content.

with following 2 lines

Please Login or Register  to view this content.

[vcsindy]

One last question...can the script add the decimal and the code extends to the cents. such as $450.12 = plk.si

[jindon]

Replace the code with the following

Please Login or Register  to view this content.

[Winon]

@ jindon,

Awesome!!!

[arkv]

Is there a way to convert the number from the left column to the aphabets. Ex cell B1 is 1, it automatically produces the result S in cell C1. (using SIMPLYWORK as the example)