Re: Convert numbers to words

[David Biddulph]

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

"wins007" <win...@discussions.microsoft.com> wrote in message
news:D3DE0046-3BF6-47BA...@microsoft.com...
> Can anyone help me with conversion of figures into words?
>
> Thks for your help

[Bernd P]

Hello,

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

And then test my number examples ...

Regards,
Bernd

[Francis]

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.aspx?scid=kb;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

[Bernd P]

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.aspx?scid=kb;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