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
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
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.
Security Amount Proof.docx
Steps to transfer PF amount.jpg
SALARY WORD.zip