thanks for yesterday's help, however, I can not seem to
arrange it to work for what I need. I tried to fill in
the info I am actually using, but I do not understand
enough programming to make it work.

my range is L2:M12
I am using 10 letters to represent numbers 1,2..8,9,0
those letters are to be typed in the "D" column, no more
than 6 consecutive letters (they will not represent a
value greater than $9,999.99

Please help...