Hi,
Save the add in file in the excel start up location (see below) and restart your excel and use the following formula "=ntow(Cell reference)" C:\Users\[user]\AppData\Roaming\Microsoft\Excel\XLSTART Regards Sathish Jalendran From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Mahesh Sent: 22 June 2009 04:09 pm To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Conversion of value in words from figures Hi, How to use this Add-in in Excel 2007. On Mon, Jun 22, 2009 at 10:13 AM, Sathish Jalendran <sath...@teamlease.com> wrote: Hi, U can use the attached addin it will solve your issue STEPS: 1)download the attachment and save it to hard disk. 2) Open excel and go to Tools -Add Ins 3)go to browse and select the smb.xla file from the location where u saved it and click OK. USE the Formula =ntow( amount in figure or cell reference Regards Sathish Jalendran From: excel-macros@googlegroups.com [mailto:excel-mac...@googlegroups.com] On Behalf Of Shiv Pratap Sent: 21 June 2009 06: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 The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments contained in it. -- With Love, Mahesh Bisht The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments contained in it. --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- 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 ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
