CAN U SEND ME THE SAME
On Tue, 31 Mar 2009 harsh shah wrote : >*Installation >Copy the attached file to the folder where excel stores the add-ins. (To >know where excel stores the add-ins, open any workbook, click on Tools - >Add-ins - Browse) >Then open an excel workbook. Click on Tools - Add-ins - Browse - Give the >path to this Addin - Ok* > >** >NO PASSWORD REQUIRED... > > >2009/3/30 S.Ashok S.Ashok <ashoki...@gmail.com> > > > Hi Guys, > > > > What is the password for amt in words in excel add-in. > > > > Pl reply asap. > > > > S.Ashok > > > > > > On Tue, Mar 24, 2009 at 12:18 AM, harsh shah <harshsha...@gmail.com>wrote: > > > >> dear all, > >> > >> i hope these files might be of some use. > >> > >> > >> > >> AmtInWords.xla is attached to this mail. It is an MS Excel Add-in to > >> convert amount available in figures to words. > >> Installation > >> Copy the attached file to the folder where excel stores the add-ins. (To > >> know where excel stores the add-ins, open any workbook, click on Tools - > >> Add-ins - Browse) > >> Then open an excel workbook. Click on Tools - Add-ins - Browse - Give the > >> path to this Addin - Ok > >> Usage > >> You can use the functions AmtInWords and AmtInWordsUS in any worksheet. > >> The syntax is: > >> =AmtInWords(decimal number/cell reference, [currency code/cell ref], [no. > >> of decimals]) > >> =AmtInWordsUS(decimal number/cell reference, [currency code/cell ref], > >> [no. of decimals]) > >> Explanation > >> The function AmtInWords gives the output in lakhs/crores. > >> The function AmtInWordsUS gives the output in million/billion. > >> The first parameter for these functions is compulsory … you can give a > >> number or the reference of a cell containing a number (absolute or > >> calculated) > >> The second parameter is the currency code. This is optional (the default > >> is INR) and is to be given if you use a different currency than INR > >> The third parameter is the number of decimals in the fraction part. This > >> is optional (the default is 2) and is to be given if it is different. At > >> present, the accepted values are 0, 2 and 3 > >> Examples > >> =AmtInWords(10000000) > >> =AmtInWords(123456.77) > >> =AmtInWords(123456.747, "OMR",3) > >> =AmtInWords(C4) > >> =AmtInWords(C4,A3) ' Where C4 contains a number and A3 a currency code > >> =AmtInWordsUS(B3) ' Shall give the amount in millions (US format) > >> =AmtInWordsUS(B3,"USD") ' Shall give the amount in millions (US format) > >> and in US currency (Dollars) > >> =AmtInWords(C4,"GBP") ' Shall give the amount in lakhs and in UK currency > >> (Pounds) > >> =AmtInWordsUS(B3,"OMR",3) ' Shall give the amount in millions and in Oman > >> currency (Omani Rial) which has upto 3 decimals in the fraction part > >> Notes > >> The system shall NOT give you any warning/error if you use: > >> =AmtInWords(C4,"USD") ' Amount in lakhs and in US currency (Dollars) > >> OR > >> =AmtInWordsUS(C4,"GBP") ' Amount in millions and in UK currency (Pounds) > >> At present 6 currency codes are supported: > >> INR (the default ... not required to be given separately) > >> USD (dollars) > >> GBP (pounds) > >> EUR (euros) > >> OMR (Omani rials) > >> BDT ( Bangladesh Taka) > >> > >> > > > > > > -- > > With warm regards, > > S.Ashok > > > > > > > > >> --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- 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 ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
