Excel SpellNumber Function for 14 Currencies

Are you looking to convert numbers into written text for various currencies within Excel? Look no further than the SpellNumber function, which supports a wide range of currencies including AUD, CAD, USD, EURO, GBP, YEN, ZAR, AED, SAR, THB, LKR, INR, PKR, and BDT. This versatile tool adds flexibility to your financial documentation.

What is the SpellNumber Function?

While Microsoft Office provides a default code for converting numbers into US Dollars, the SpellNumber function expands this capability to accommodate multiple currencies. This means you can represent a given number not just in US Dollars, but also in various other currencies like Euros, Yen, Pounds, and more.

How to Use the SpellNumber Function

To incorporate the SpellNumber function into your Excel workbook, follow these steps:

1. Open Microsoft Excel and access the Visual Basic Editor.
2. Click on Module and insert the provided VBA code from the link.
3. Save your workbook as a macro-enabled file to retain the functionality.

Using SpellNumber for Different Currencies

1. US Dollars (USD): Enter the function without any parameter to display amounts in dollars and cents. For example, “Two Thousand Three Hundred Forty-Five Dollars and Fifty Cents.”
2. Canadian Dollars (CAD): Use the “CA” parameter for Canadian dollars. For instance, “Two Thousand Three Hundred Forty-Five Canadian Dollars and Fifty Cents.”
3. Australian Dollars (AUD): Specify “AU” for Australian dollars. Example: “Two Thousand Three Hundred Forty-Five Australian Dollars and Fifty Cents.”
4. Euros (EUR): Insert “AU” to represent amounts in Euros. Example: “Two Thousand Three Hundred Forty-Five Euros and Fifty Cents.”
5. Great Britain Pounds (GBP): Use “UK” for British pounds. Example: “Two Thousand Three Hundred Forty-Five Pounds and Fifty Pence.”
6. Japanese Yen (YEN): Insert “JY” for Japanese Yen. Example: “Two Thousand Three Hundred Forty-Five Yen and Fifty Sens.”
7. UAE Dirham (AED): Use “DH” to denote UAE Dirhams. Example: “Two Thousand Three Hundred Forty-Five Dirhams and Fifty Fils.”
8. Saudi Riyal (SAR): Specify “RY” for Saudi Riyals. Example: “Two Thousand Three Hundred Forty-Five Riyals and Fifty Halalas.”
9. South African Rand (ZAR): Use “SA” for South African Rands. Example: “Two Thousand Three Hundred Forty-Five Rands and Fifty Cents.”
10. Thai Baht (THB): Insert “TB” for Thai Bahts. Example: “Two Thousand Three Hundred Forty-Five Bahts and Fifty Satangs.”
11. Sri Lankan Rupee (LKR): Specify “SR” for Sri Lankan Rupees. Example: “Two Thousand Three Hundred Forty-Five Rupees and Fifty Sinhalas.”
12. Indian Rupee (INR): Utilize the provided VBA code for Indian Rupees. Example: “Two Thousand Three Hundred Forty-Five Rupees and Fifty Paisas.”
13. Pakistani Rupee (PKR): Specify “PK” for Pakistani Rupees. Example: “Two Thousand Three Hundred Forty-Five Pakistani Rupees and Fifty Paisas.”
14. Bangladeshi Taka (BDT): Use “BD” for Bangladeshi Takas. Example: “Two Thousand Three Hundred Forty-Five Taka and Fifty Poysha.”

SpellNumber Function Without Currency

If you need to convert numbers into written text without specifying a currency, the SpellNumbeWC function comes in handy. Simply insert this function without any parameters, and it will display the number in English words without currency symbols.

Feel free to share this functionality with your network on social media. If you have any questions or suggestions, please leave them in the comments section below. We’re here to help!

Remember, sharing is caring. Let others benefit from this useful tool as well.

FAQs about the SpellNumber Excel Function for Multiple Currencies

1. What is the SpellNumber function in Excel?

• The SpellNumber function in Excel is a VBA (Visual Basic for Applications) code that converts numerical values into written text, including currency denominations, such as dollars, euros, pounds, and more.

1. How many currencies does the SpellNumber function support?

• The SpellNumber function supports conversion for 14 different currencies, including AUD, CAD, USD, EURO, GBP, YEN, ZAR, AED, SAR, THB, LKR, INR, PKR, and BDT.

1. Can I use the SpellNumber function for currencies other than US dollars?

• Yes, the SpellNumber function extends beyond US dollars to include various other currencies, allowing users to represent numeric values in different currency denominations.

1. How do I use the SpellNumber function in Excel?

• To use the SpellNumber function, you need to insert the provided VBA code into your Excel workbook. This code enables the conversion of numerical values into written text for the specified currency.

1. Is the SpellNumber function compatible with all versions of Excel?

• The SpellNumber function relies on VBA code, which is supported in most versions of Excel. However, users should ensure that macros are enabled in their Excel settings to utilize this function effectively.

1. Can I customize the SpellNumber function for specific currency formatting?

• Yes, the SpellNumber function allows for customization by specifying parameters for different currencies. For example, you can indicate the currency code or abbreviation to tailor the formatting according to your requirements.

1. Are there any limitations to using the SpellNumber function?

• While the SpellNumber function offers versatility in converting numerical values into written text for various currencies, users should be aware that it may not accommodate extremely large numbers or complex formatting requirements.

1. Can I share the SpellNumber function with others?

• Yes, you can share the SpellNumber function and its associated VBA code with others by providing them access to the code or sharing the Excel workbook containing the function. Sharing this functionality can help others streamline their financial documentation processes.

1. Does the SpellNumber function support multiple languages?

• The SpellNumber function primarily converts numerical values into written text in English. While it may not directly support other languages, users can adapt the function or its output to suit their language preferences with additional customization.

1. Where can I find more information about the SpellNumber function?
   • For additional information about the SpellNumber function, including usage instructions, examples, and troubleshooting tips, you can refer to online resources, forums, or documentation related to Excel and VBA programming.