Is it always after any Hundred unless an even Hundred? If so you maybe you
could use something like

=IF(MOD(A1,100)=0,spellnumber(A1),SUBSTITUTE(spell number(A1),"Hundred","Hundred
and"))

--
Regards,

Peo Sjoblom

(No private emails please)


"Ken G." wrote in message
...
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,