Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to calculate number of occurencies of a specific number number | Excel Discussion (Misc queries) | |||
Formula to change scientific number to regular number or text | Excel Discussion (Misc queries) | |||
convert text-format number to number in excel 2000%3f | Excel Discussion (Misc queries) | |||
Count number of times a specific number is displayed in a cell ran | Excel Worksheet Functions | |||
Rounding a number to a multiple quantity that adds to a fixed total number | Excel Worksheet Functions |