number to text

[torpido]

hi guys
ive tried to search the forum to find the answer but the searc
function is not working or u can say its kinda dead slow, so forgive m
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 th
language is diffrent, help page says i must change the reginal optio
in Cp but i cant find a usefull thing there.
i also found many articals on google search saying to the cel
formating trick, but it doesnt do any thing

 

[Paul Sheppard]

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.

Hi torpido

have a look at these

http://www.xldynamic.com/source/xld.xlFAQ0004.html

http://support.microsoft.com/defaul...B;EN-US;Q213360

 

[torpido]

dude ur great, thanks for the links they did work perfictly, shame MS
had to do it for US currency only.

 

[Paul Sheppard]

dude ur great, thanks for the links they did work perfictly, shame MS
had to do it for US currency only.

Hi torpido

If you don't want dollars and cents try changing the code the to suit

 

[Andy Wiggins]

This file might be a help:
http://www.bygsoftware.com/examples/zipfiles/num2wrds.zip

It's in the "Accountants" section on page:
http://www.bygsoftware.com/examples/examples.htm
It contains the "SPELLNUMBER" function, which can be used in your
spreadsheets, two methods to convert numbers to words and two cheque
writing routines.

The code is open and commented.

 

[Ron Rosenfeld]

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 are:

. 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

 

[torpido]

Hi torpido

have a look at these

http://www.xldynamic.com/source/xld.xlFAQ0004.html

http://support.microsoft.com/defaul...B;EN-US;Q213360

hi
sorry to bug u again
the MS Script(2nd link) disables after re-launchign the sheet.
i mean 1st time when i add the modul it works perfictly and i di
replace the cent and dollar with my own currency(thanks for ur tip) bu
when i close the sheet and re open it i get the error sign on the cel
where ive seted the =spellnumber code, it gives me the #Name error o
the cell, just like when u put a wrong function.
then i must delete the modul and save the sheet without it and re ope
then re-enter the modul.
am i doing something wrong, and other link(Morefunc) works too but i
doesnt adds currecy in it.
EDIT:
I managed to work the MoreFunc with my own currency, but i couldnt se
the "after point" like Cents.
but my concern is that am trying to do this thing on my office pc an
my account is limited, i think i wont be able to install the MoreFun
on it so i need the MS script to work. if somebody can tell me why i
screws up on every re-luanch ill be greatfull

 

[Ron Rosenfeld]

I managed to work the MoreFunc with my own currency, but i couldnt set
the "after point" like Cents.

You should be able to.

Post a sample of the raw number and how you want it displayed, and I should be
able to give you the proper syntax.


--ron

 

[torpido]

i already managed to do it,
thanks

 

[crestendo]

i want to convert no. e.g. 100 to text as one hundred