Dear Shiv Pratap There is no built in function in excel to do it. You have to use custom made function for the same which are quite difficult to come by (even ASAP utilities does not provide for one!).
CA_logo_icai Small1 Anil Kumar Agarwala Anil Agarwala & Co. Chartered Accountants 3rd Floor, Adiba Mansion Maszid Lane, Kamarpatty Fancy Bazar Guwahati : 781001 Assam +91 361 2638864 (Telefax) +91 361 2517820 (Office) +91 361 2606184 (Residence) +91 9435086605 (Mobile) <mailto:akagarw...@gmail.com> akagarw...@gmail.com From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Shiv Pratap Sent: Sunday, June 21, 2009 6:43 PM To: excel-macros@googlegroups.com Cc: megaliving_corporat...@yahoo.com; megaliving.corporat...@gmail.com; vibhor_rast...@baxter.com Subject: $$Excel-Macros$$ Conversion of value in words from figures Hi Friends, I have a simple query in my mind. I just wants to know that is it possible to convert a numeric value written in a cell in figures into words in another cell. For Example :- Numeric value in figures = 123 Value in words = One hundred twenty three If it is possible then plzz suggest me the way. Regards Shiv Pratap --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
<<inline: image001.jpg>>
