how can I add some other currency codes On Mon, Mar 23, 2009 at 9:48 PM, 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) > > --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- 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 ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
