CD,

You could simply use

=TRIM(Spellnumber(A1))

HTH,
Bernie
MS Excel MVP


"CD" wrote in message
...
How to convert number to text with proper accounting for Cheque Printing.

10101.01 = Ten Thousand One Hundred One and One Only.
1000.00 = One Thousand Only.
1060.00 = One Thousand Sixty Only.

I try a few posting solution, but for some result not properly done as i
need.

=SpellNumber(A1)
If 1061 result "ONE THOUSAND SIXTY ONE ONLY" but if 1060 result "ONE
THOUSAND SIXTY ONLY" with double space between "SIXTY" and "ONLY" but
single
space between "SIXTY" and "ONE".