How do I convert Arabic numbers into a spellout text

G

Guest

I frequently use Excel for Finance purposes, create receipt, payment voucher,
purchase order, etc. In addition to the Arabic number, my office requires
that I spell out the nominal that we write on the document. I've seen the
=BAHTTEXT() function on Excel but failed to apply it for any other language
or currency.
 
R

Ron Rosenfeld

I frequently use Excel for Finance purposes, create receipt, payment voucher,
purchase order, etc. In addition to the Arabic number, my office requires
that I spell out the nominal that we write on the document. I've seen the
=BAHTTEXT() function on Excel but failed to apply it for any other language
or currency.
Click to expand...

Look at the NBTEXT function in Laurent Longre's morefunc.xll free add-in.

It is downloadable from http://xcell05.free.fr/english/ (or in French if you
prefer) and has options for 13 different languages for this function.


--ron
 

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

How do I get Arabic numbers converted to English text format? 1
how do i convert numbers to words 2
How do I change Hindi number to Arabic numbers in a Word document. 2
how do i convert numbers (25) into words (Twenty Five Only) ... 1
How do I convert a number in Excel such as 1001-1 to 1001-01? 2
How do I convert an excel worksheet into a word document? 1
How to convert text to numbers 5
How do I convert text to numbers in an old version of excel 2

Top