AmtInWords.xla is attached to this mail. It is an MS Excel Add-in written by me to convert amount available in figures to words.
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
You can use the functions AmtInWords and AmtInWordsUS in any worksheet. The syntax is:
=AmtInWords(decimal number/cell reference, [currency code])
=AmtInWordsUS(decimal number/cell reference, [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)
The system shall NOT give you any warning/error if you use:
=AmtInWords(C4,"USD") ' Amount in lakhs and in US currency (Dollars)
=AmtInWordsUS(C4,"GBP") ' Amount in millions and in UK currency (Pounds)
At present 3 currency codes are supported:
INR (the default ... not required to be given separately)
Let me know how you find it and/or your suggestions.
12 September 2005
ICAI: Registration for the 2nd Batch of *Five Days Residential Programme on Advanced Leadership for Chartered Accountants at IIM Ahmedabad *...
We are Live with WIRC and CC election 2018 updates Stay Tuned...
Here is our projection for 1st Preference votes for WIRC. Please provide your comments below. We will discuss and revise this again till we ...
Status after elimination of Sarvesh Joshi: Recount request is made.. will update .. Rank Sr No. Name Ci...