View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Ken G.
 
Posts: n/a
Default Adding "and" to Spellnumber code

Here in Australia $261,345 would be written as "Two hundred and sixty one
thousand three hundred and forty five dollars" Note the two "ands" in there.
Can some kind soul tell me how to modify the Spellnumber routine to do this.
I've tried but can't get it right with either too many, or not enough "and"s
appearing, or appearing in the wrong place. (Its interesting that we say "two
hundred AND one" or "two hundred AND sixty one", but we don't say "forty AND
five")

Thanks,