Convert numbers to words

Can anyone help me with conversion of figures into words?

Thks for your help

See this, probably one of the best sites that I've seen for this task

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

orfrom Microsoft site
http://support.microsoft.com/default...b;en-us;213360
1E+15 Hundred Fifteen Dollars and No Cents
0.123 No Dollars and Twelve Cents
1.00 One Dollar and No Cents
20.123 Twenty Dollars and Twelve Cents
-20.123 Hundred Twenty Dollars and Twelve Cents
1.01 One Dollar and One Cent
1000001.01 One Million One Dollars and One Cent
--
Hope this is helpful

Pls click the Yes button below if this post provide answer you have asked

Thank You

cheers, francis

Am not a greek but an ordinary user trying to assist another



"wins007" wrote:

Can anyone help me with conversion of figures into words?

Thks for your help

http://support.microsoft.com/kb/213360
http://www.xldynamic.com/source/xld.xlFAQ0004.html
http://www.ozgrid.com/VBA/ValueToWords.htm
--
David Biddulph

"wins007" wrote in message
news
Can anyone help me with conversion of figures into words?

Thks for your help

Hello,

No :-) Have a look at http://www.sulprobil.com/html/spellnumber.html

And then test my number examples ...

Regards,
Bernd

Hello Francis,

Are you aware of what you suggest?

http://www.xldynamic.com/source/xld.xlFAQ0004.html
(the VBA code) returns for
1000000000000000 "One Dollar Only"
0.123 "Dollars And 12"

Microsofts site http://support.microsoft.com/default...b;en-us;213360
returns for
1000000000000000 "Hundred Fifteen Dollars and No Cents"
-20.123 "Hundred Twenty Dollars and Twelve Cents"

In my humble opinion you should NOT use these programs because do not
apply a proper parameter check.

I suggest to use http://www.sulprobil.com/html/spellnumber.html
instead.

Regards,
Bernd