![]() |
Convert a number to phrase
I have to prepare an invoice where beside stating the value of the invoice, I
also have to type the value in words. An axample is $1,234.50 and it will be converted to "One Thousand Two Hundred Thirty Four and Cent Fifty" |
Convert a number to phrase
Take a look at these sites:
http://support.microsoft.com/default...b;en-us;213360 http://www.xldynamic.com/source/xld.xlFAQ0004.html http://www.ozgrid.com/VBA/ValueToWords.htm "Shahrun A Rahman" wrote: I have to prepare an invoice where beside stating the value of the invoice, I also have to type the value in words. An axample is $1,234.50 and it will be converted to "One Thousand Two Hundred Thirty Four and Cent Fifty" |
Convert a number to phrase
Hello,
I suggest to use http://www.sulprobil.com/html/spellnumber.html My function offers more parameter checks than others (test other suggestions with input values shown on my page). It is being used in banks but read my disclaimer, please. Regards, Bernd |
All times are GMT +1. The time now is 02:41 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com