No Tags Found!

apeksha.kali
Dear All,
Hope you find this usefull.
AmtInWords.xla is attached to this mail. It is an MS Excel Add-in written 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])
=AmtInWordsUS(decimal number/cell reference, [currency code])
Examples follow:
=AmtInWords(10000000)
=AmtInWords(123456.77)
=AmtInWords(C4)
=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)
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 3 currency codes are supported:
1. INR (the default ... not required to be given separately)
2. USD
3. GBP

From India, Mumbai
Attached Files (Download Requires Membership)
File Type: zip convert amount in figures to words.zip (16.1 KB, 3513 views)

Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.





Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2024 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.