number to text
 

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.


--
torpido
------------------------------------------------------------------------
torpido's Profile: http://www.excelforum.com/member.php...o&userid=26482
View this thread: http://www.excelforum.com/showthread...hreadid=397468

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.

Hi torpido

have a look at these

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

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


--
Paul Sheppard


------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=397468

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


--
torpido
------------------------------------------------------------------------
torpido's Profile: http://www.excelforum.com/member.php...o&userid=26482
View this thread: http://www.excelforum.com/showthread...hreadid=397468

torpido Wrote:
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


--
Paul Sheppard


------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=397468

This file might be a help:
http://www.bygsoftware.com/examples/...s/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.


--
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy
-

"torpido" wrote in
message ...

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.


--
torpido
------------------------------------------------------------------------
torpido's Profile:
http://www.excelforum.com/member.php...o&userid=26482
View this thread: http://www.excelforum.com/showthread...hreadid=397468

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

Paul Sheppard Wrote:
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 did
replace the cent and dollar with my own currency(thanks for ur tip) but
when i close the sheet and re open it i get the error sign on the cell
where ive seted the =spellnumber code, it gives me the #Name error on
the cell, just like when u put a wrong function.
then i must delete the modul and save the sheet without it and re open
then re-enter the modul.
am i doing something wrong, and other link(Morefunc) works too but it
doesnt adds currecy in it.
EDIT:
I managed to work the MoreFunc with my own currency, but i couldnt set
the "after point" like Cents.
but my concern is that am trying to do this thing on my office pc and
my account is limited, i think i wont be able to install the MoreFunc
on it so i need the MS script to work. if somebody can tell me why it
screws up on every re-luanch ill be greatfull.


--
torpido
------------------------------------------------------------------------
torpido's Profile: http://www.excelforum.com/member.php...o&userid=26482
View this thread: http://www.excelforum.com/showthread...hreadid=397468

On Sun, 21 Aug 2005 06:33:33 -0500, torpido
wrote:

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

i already managed to do it,
thanks


--
torpido
------------------------------------------------------------------------
torpido's Profile: http://www.excelforum.com/member.php...o&userid=26482
View this thread: http://www.excelforum.com/showthread...hreadid=397468

number to text
 

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




Ron Rosenfeld Wrote:
On Sun, 21 Aug 2005 06:33:33 -0500, torpido
wrote:

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


--
crestendo
------------------------------------------------------------------------
crestendo's Profile: http://www.excelforum.com/member.php...o&userid=34259
View this thread: http://www.excelforum.com/showthread...hreadid=397468