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