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
|
|||
|
|||
Number to Teat
Dear All
I would like to Print the Number to Text ... Examble If cell contains the value of : 1000 : convert to " ONE THOUSAND " Pls Help Regards Syed |
#2
|
|||
|
|||
Number to Teat
Numbers to words
http://www.sulprobil.com/html/spellnumber.html 1E+15 Error (Absolute amount 999999999999999)! 0,123 Zero Dollars and Twelve Cents (rounded) -1 Minus One Dollar and Zero Cents 20,123 Twenty Dollars and Twelve Cents (rounded) -20,123 Minus Twenty Dollars and Twelve Cents (rounded) 1,01 One Dollar and One Cent 1000001,01 One Million One Dollars and One Cent http://www.contextures.com/excelfilesRon.html (VBA) 1E+15 #ZAHL! 0,123 No Dollars and No Cents -1 #WERT! 20,123 Twenty Dollars and No Cents -20,123 #WERT! 1,01 One Dollar and No Cents 1000001,01 One Million One Dollars and No Cents 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 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 http://www.ozgrid.com/VBA/ValueToWords.htm 1E+15 Hundred Fifteen Dollars and No Cents 0,123 No Dollars and Twelve Cents -1 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 Please note that in German Excel the "," represents the "." but you should get similar results. IMHO any serious spellnumber function should check its inputs thoroughly and all your suggested versions DON'T (to be fair to XLDynamics, I did not check recently, so that's maybe an outdated status of information). copied from a reply by Bernd Plumhoff long ago best wsihes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Syed Ali Abjimiah" Syed Ali wrote in message ... Dear All I would like to Print the Number to Text ... Examble If cell contains the value of : 1000 : convert to " ONE THOUSAND " Pls Help Regards Syed |
#3
|
|||
|
|||
Number to Teat
Dear Friend
Thanks for your ails... i would like to have Indian Format "Bernard Liengme" wrote: Numbers to words http://www.sulprobil.com/html/spellnumber.html 1E+15 Error (Absolute amount 999999999999999)! 0,123 Zero Dollars and Twelve Cents (rounded) -1 Minus One Dollar and Zero Cents 20,123 Twenty Dollars and Twelve Cents (rounded) -20,123 Minus Twenty Dollars and Twelve Cents (rounded) 1,01 One Dollar and One Cent 1000001,01 One Million One Dollars and One Cent http://www.contextures.com/excelfilesRon.html (VBA) 1E+15 #ZAHL! 0,123 No Dollars and No Cents -1 #WERT! 20,123 Twenty Dollars and No Cents -20,123 #WERT! 1,01 One Dollar and No Cents 1000001,01 One Million One Dollars and No Cents 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 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 http://www.ozgrid.com/VBA/ValueToWords.htm 1E+15 Hundred Fifteen Dollars and No Cents 0,123 No Dollars and Twelve Cents -1 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 Please note that in German Excel the "," represents the "." but you should get similar results. IMHO any serious spellnumber function should check its inputs thoroughly and all your suggested versions DON'T (to be fair to XLDynamics, I did not check recently, so that's maybe an outdated status of information). copied from a reply by Bernd Plumhoff long ago best wsihes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Syed Ali Abjimiah" Syed Ali wrote in message ... Dear All I would like to Print the Number to Text ... Examble If cell contains the value of : 1000 : convert to " ONE THOUSAND " Pls Help Regards Syed |
Thread Tools | |
Display Modes | |
|
|