If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Convert numbers to words
Can anyone help me with conversion of figures into words?
Thks for your help |
#2
|
|||
|
|||
Convert numbers to words
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 |
#3
|
|||
|
|||
Convert numbers to words
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 |
#4
|
|||
|
|||
Convert numbers to words
Hello,
No :-) Have a look at http://www.sulprobil.com/html/spellnumber.html And then test my number examples ... Regards, Bernd |
#5
|
|||
|
|||
Convert numbers to words
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 |
Thread Tools | |
Display Modes | |
|
|