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