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.

On Mon, 11 Apr 2005 02:55:02 -0700, Widodo
wrote:

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.

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