SpellNumber is a manually created function through VBA Programming to change a number to written text. In other words, it converts a numeric value into English words with currency.
In this article, we will learn step by step how to create this SpellNumber function using the VBA Function.
For example, I have $ 2,345.50 need to be displayed as “Dollar Two Thousand Three Hundred Forty-Five and Fifty Cents”.
The SpellNumber macro does as its name suggests. You will be able to find all other macros with minor changes in currency, calculations, digits, etc. They all are based on the Microsoft code.
There is no direct function in Microsoft Excel to perform the above action. However, as many and many users demanded, they created and published the special VBA macro code on their website.
Steps to create the SpellNumber Function
Step 1: Start Microsoft Excel.
Step 2: Press ALT+F11 to open the Visual Basic Editor.
Step 3: On the Insert menu, click Module.
Step 4: Copy and Paste the below code into the Module sheet.
Code For SpellNumber Dollars
Step 5: Press Ctrl+S to save the workbook. As this workbook now contains a macro, while saving Excel will display the following message “The following features cannot be saved in macro-free workbook”. Click “No”.
You will see a new dialog. Select the “Save As” option.
From the drop-down menu select the “Save as type” as “Excel macro-enabled workbook”.
We are done with creating the function in your workbook. One thing is to be kept in mind that this function will only be available in this workbook.
As you plan to change workbook, it is necessary to paste the code for each workbook by following the above-mentioned steps.
Note: Our workbook now contains a macro. Each time you open this workbook or any other macro-enabled workbook, a security warning will appear below the ribbon. Select the “Enable this content” option and click OK.
Here in this article, I have shown the way to create SpellNumber for Dollar currency. You can also create it for other available currencies. Minor changes are there depending on the countries.
We thank our readers for liking, sharing and following us on different social media platforms.
If you have any queries please share in the comment section below. I will be more than happy to assist you.