how to convert nos from figures to words
in [General]
|
Prev: kopirovanie bez zvysovania hodnoty
Next: Adding multiple items in unordered data to match a target amount
From: Dinesh Jain Dinesh on 16 Apr 2010 08:39 example while i m wrtng a cheque I need amount in words. so i want simply convert amt in figures to words.
From: Jacob Skaria on 16 Apr 2010 08:43 There is no direct functions to convert this. For a VBA solution check out the below links http://www.ozgrid.com/VBA/ValueToWords.htm http://support.microsoft.com/kb/213360 http://www.xldynamic.com/source/xld.xlFAQ0004.html -- Jacob (MVP - Excel) "Dinesh Jain" wrote: > example while i m wrtng a cheque I need amount in words. > so i want simply convert amt in figures to words.
From: Mike H on 16 Apr 2010 08:46 Hi, There's lots of code on the net to do this but the one I like is the ADDIN Morefunc. You can get it at the end of the link below http://download.cnet.com/Morefunc/3000-2077_4-10423159.html -- Mike When competing hypotheses are otherwise equal, adopt the hypothesis that introduces the fewest assumptions while still sufficiently answering the question. "Dinesh Jain" wrote: > example while i m wrtng a cheque I need amount in words. > so i want simply convert amt in figures to words.
From: Shailesh Shah on 16 Apr 2010 09:55
If you want as per Indian Rupees you can download "Rupees in Word" comaddins from below site. http://shahshaileshs.web.officelive.com/documents/comaddins.htm BTW here is download link for another related addins. "Indian Rupees" http://shahshaileshs.web.officelive.com/Addins.aspx "SpellNoFormula " + "IndianSpellNoFormula " + " IndianSpellNoFormulaHindi " http://shahshaileshs.web.officelive.com/Misc.aspx "Rupees in Hindi Word Ver. 1.00" http://shahshaileshs.web.officelive.com/ComAddins.aspx Regards, Shailesh http://shahshaileshs.web.officelive.com/ If You Can't Excel with Talent, Triumph with Effort. Free Addins Office Menu-2003 for Office-2007 http://shahshaileshs.web.officelive.com/MenuAddins.aspx Free Exshail Classic Menu for Excel-2007 http://shahshaileshs.web.officelive.com/Exshail_Classic_Menu.aspx Use Free Accounting Software as per Principle of Book Keeping having Vat enabled Invoice Printing and Vat Computation with Inventory and Drill-down Reports by Busy Infotech: http://www.busy.in/index.php?p=fas "Dinesh Jain" <Dinesh Jain(a)discussions.microsoft.com> wrote in message news:0653C077-908D-4635-A87E-E4CB69B41102(a)microsoft.com... > example while i m wrtng a cheque I need amount in words. > so i want simply convert amt in figures to words. |