Dear All,
Hope you find this useful. AmtInWords.xla is attached to this email. It is an MS Excel Add-in written to convert amounts 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 Add-in - 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:
- =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
Thank you.
From India, Mumbai
Acknowledge(0)
Amend(0)
Hope you find this useful. AmtInWords.xla is attached to this email. It is an MS Excel Add-in written to convert amounts 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 Add-in - 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:
- =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
Thank you.
From India, Mumbai
Acknowledge(0)Amend(0)
Hello,
It's great to see you using the Excel Add-in AmtInWords.xla to convert numerical amounts into words. Here's a little more help on how you can use this tool more effectively:
1. Installation:
- Copy the attached AmtInWords.xla file to the folder where Excel stores its add-ins.
- Open Excel, click on Tools > Add-ins > Browse. This will show you where Excel is storing its add-ins.
- Open a new workbook, go to Tools > Add-ins > Browse again and give the path to the AmtInWords.xla add-in.
2. Usage:
- You can use the functions 'AmtInWords' and 'AmtInWordsUS' in any worksheet.
- Example: =AmtInWords(123456.77) will convert 123456.77 into words.
- =AmtInWordsUS(B3) will give the amount in millions (US format).
3. Currency codes:
- You can use three currency codes: INR (default), USD, and GBP.
- Example: =AmtInWordsUS(B3,"USD") will give the amount in millions (US format) and in US currency (Dollars).
📌 Please note: the system will not give you a warning/error if you use =AmtInWords(C4,"USD") or =AmtInWordsUS(C4,"GBP").
Remember, this tool is a great way to avoid any mistakes in writing amounts in words, especially for financial documents or checks where accuracy is critical.
Hope this helps! If you have any more queries, feel free to ask.
🌟 Happy Excelling!
From India, Gurugram
Acknowledge(0)Amend(0)
51It's great to see you using the Excel Add-in AmtInWords.xla to convert numerical amounts into words. Here's a little more help on how you can use this tool more effectively:
1. Installation:
- Copy the attached AmtInWords.xla file to the folder where Excel stores its add-ins.
- Open Excel, click on Tools > Add-ins > Browse. This will show you where Excel is storing its add-ins.
- Open a new workbook, go to Tools > Add-ins > Browse again and give the path to the AmtInWords.xla add-in.
2. Usage:
- You can use the functions 'AmtInWords' and 'AmtInWordsUS' in any worksheet.
- Example: =AmtInWords(123456.77) will convert 123456.77 into words.
- =AmtInWordsUS(B3) will give the amount in millions (US format).
3. Currency codes:
- You can use three currency codes: INR (default), USD, and GBP.
- Example: =AmtInWordsUS(B3,"USD") will give the amount in millions (US format) and in US currency (Dollars).
📌 Please note: the system will not give you a warning/error if you use =AmtInWords(C4,"USD") or =AmtInWordsUS(C4,"GBP").
Remember, this tool is a great way to avoid any mistakes in writing amounts in words, especially for financial documents or checks where accuracy is critical.
Hope this helps! If you have any more queries, feel free to ask.
🌟 Happy Excelling!
From India, Gurugram
Acknowledge(0)Amend(0)CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.
Mobile codes excel 2nd addition.xls
Currency symbol in excel.zip
Advanced Excel 2003.pdf