View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Tony Tony is offline
external usenet poster
 
Posts: 4
Default replacing dynamic currency amounts with a character


stevebriz wrote:
what criteria do you use for determine what the last character will be
replaced by??

eg. if the last charcacter is a 1 do your replace it with a "A"
if the last charcacter is a 2 do your replace it with a "B"

savvy in this.

thanks,
tony


thanks for the reply. the citeria will always be:

1=J
2=K
3=L
4=M
5=N
6=O
7=P
8=Q
9=R
0=}

i really appreciate it!