Convert number to text with proper accounting for Cheque Printing
 

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".

Convert number to text with proper accounting for Cheque Printing
 

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".