converting a number into text

[Guest]

hi,
I have a column A with numbers ie. 104, 115, 130. I want column B to
indicate this number in writing ie. One Hundred and four, One Hundred
fifteen, One Hundred thirty. I think this is possible but i dont know the way
to do it.

I found the BAHTTEXT function, but i think i get the result in Thai
language!!!??! is it possible to get it in english or greek even?

thank you.

 

[Frank Kabel]

Hi
there're some macros/procedures to convert numbers to text. e.g.
MS Knowledge Base:
http://support.microsoft.com/default.aspx?scid=KB;EN-US;213360
http://support.microsoft.com/default.aspx?scid=KB;EN-US;140704&

Free Addin MOREFUNC-DLL which includes a UDF for this task (for various
languages):
http://longre.free.fr/english/

or have a look at
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 two methods

 

[Paul B]

bel, have a look here
http://support.microsoft.com/default.aspx?scid=kb;[LN];Q95640

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **