Convert Number to Text (Words)

B

brianb

I am looking for a way to convert numbers (10,000) to text
(words(ten thousand))?????

any help would be HUGE

cheers,
brian
 
F

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

convert numbers to words 3
how to convert number to words 4
How convert Numeric number in words 2
how do i convert numbers (25) into words (Twenty Five Only) ... 1
CONVERT NUMBER TO TEXT 2
convert number to intext 0
how to convert numbers into words 1
how to convert decimal numbers to words 2

Top