Convert number to text with proper accounting for Cheque Printing

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Currency to text 1
convert number into text & Only 3
Convert number to word in indian currency 2
Convert Text to Number 2
Conversion from Number to Word!! Aki 1
Display Numbers as Words 3
CONVERT NUMBER TO TEXT 2
Convert number to word 5

Top