Convert number to text with proper accounting for Cheque Printing

  • Thread starter Thread starter CD
  • Start date Start date
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".
 
CD,

You could simply use

=TRIM(Spellnumber(A1))

HTH,
Bernie
MS Excel MVP
 
You must log in or register to reply here.

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

Change amount into english words according to Indian format 4
Convert Number to words 1
Currency to text 1
convert number into text & Only 3
Convert number to word in indian currency 2
Convert Text to Number 2
Convert Numbers to Text 2
Display Numbers as Words 3

Back
Top