How do I convert Arabic numbers into a spellout text

W

Widodo

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
 
Top