ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I convert Arabic numbers into a spellout text (https://www.excelbanter.com/excel-worksheet-functions/21412-how-do-i-convert-arabic-numbers-into-spellout-text.html)

Widodo

How do I convert Arabic numbers into a spellout text
 
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.

Ron Rosenfeld

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


All times are GMT +1. The time now is 07:38 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com