On Sat, 20 Aug 2005 09:18:34 -0500, torpido
wrote:


hi guys
ive tried to search the forum to find the answer but the search
function is not working or u can say its kinda dead slow, so forgive me
if its been asked before.
how to convert an amount(number) to text.
eg:
1234
one thousand two hundred thirty four

i tried a formula called BAHTTEXT, its supposed to do the job but the
language is diffrent, help page says i must change the reginal option
in Cp but i cant find a usefull thing there.
i also found many articals on google search saying to the cell
formating trick, but it doesnt do any thing.

Download and install Longre's morefunc.xll from http://xcell05.free.fr/ and use
the NBTEXT function.

If you are using this for currency, you can specify the currency units of your
choice in function arguments. The function language arguments a

. 0 or omitted = default (language of the current Windows version)
. 1 = German
. 2 = English
. 3 = Danish
. 4 = Spanish
. 5 = Esperanto
. 6 = French (standard)
. 7 = French (Belgian)
. 8 = French (Swiss)
. 9 = Italian
. 10 = Dutch
. 11 = Norwegian
. 12 = Portuguese
. 13 = Swedish


--ron