Assuming your Price is in cell A1, put this formula in cell B1 and copy it
over to cell K1...........

=IF(LEN($A1)=COLUMN(A1),LOOKUP(MID($A1,COLUMN(A1) ,1)*1,{0,1,2,3,4,5,6,7,8,9},{"Y","G","O","L","D"," E","N","C","I","T"}),"")

Then, if you wish the new "Alpha-code" to all be in one cell, you can put
this formula in cell L1

=CONCATENATE(B1,C1,D1,E1,F1,G1,H1,I1,J1,K1)

All formulas above can be copied down as needed.........

hth
Vaya con Dios,
Chuck, CABGx3




"Rao Ratan Singh" wrote:

I want to generate price list with this

G = 1
O = 2
L = 3
D = 4
E = 5
N =6
C= 7
I = 8
T = 9
Y = 0

When i enter 100 it should return GYY

HOW IT IS POSSIBLE

Thanks and regards

RRS