You can make a one time 2 columns table with the dollar values in
the left column and their text codes adjacent in the right column, you can
put it in a hidden sheet then just use something like


=IF(A2="","",VLOOKUP(A2,hidden_Sheet!A1:B50,2,0))

If you really mean converting you need to post more info since it is unclear
what logic you are using

--
Regards,

Peo Sjoblom



"Traye" wrote in message
...
I am in the wholesale business and I am wanting to take a number code and
convert it to a text code. For example
$3.50 would equal GTD
Is there anyone who could help me with this issue. Thank You