Spell Number into Word in Microsoft Excel Workbook
In this article, you are about to read the method by which you can convert amount or number into words. This feature is very demanding by MS Office users.
THE PROBLEM
Ohh, for your information let me tell you that there is no inbuild formula into Excel, which can automatically convert or display your numerical amount value in word. You can check it right now if you can find any. MS Office users demanding this feature for a long time but I don't know why Microsoft still has not considered introducing it in Excel, it seems they are not intended to do so, anyway.
THE FIX
There is always some quick fix for all the problems. To accomplish this task we have two methods:
1. By using VBA script Coding.
- which a temporary method, why I am writing it temporary solution I will tell you later in this article.
2. By using Add-Ins for Excel.
- which is quite stable than VBA Script Coding.
Watch the Demonstration Video if you don't want to Read the Whole Article:
THE WAY
First of all, we will know about how can we do this task by using a VBA script then we will learn about Add-Ins.
So first thing first,
to accomplish your task by VBA script coding you need codes that you can download from this Link (NumberToWord.txt).
Then:
1. Open that desired Excel workbook in which you want to perform that number to word conversion task.
2. After opening that Workbook, Press & Hold the ALT key and then press the F11 key together on your keyboard.
- It will open a Microsoft Visual Basic coding window, where you can find your opened workbook on the left side panel.
4. Then select INSERT in the top Ribbon Menu, you will find the Module option in it, just click on it.
- (It will add a Module in your selected Workbook, So if you have opened multiple workbooks then mind your selection before clicking on the Module).
6. Now open the NumberToWord.txt file you have downloaded from the above-provided link. Copy the whole code from the file and paste it into this VBA script window.
7. Select the File in the Top Menu and save your workbook as a macro-enabled Workbook, not the simple one, otherwise, the VBA Script won't work.
8. Close the VBA script coding window.
9. Now, select any desired cell and type " =spellnumber(CELL_WITH_AMOUNT)". Then press ENTER.
Why VBA is a Temporary Solution? || The Drawbacks ||
Now, I will tell you why I am saying that VBA is a Temporary Fix for your problem. This method has some limitations:
1. It will work on that particular workbook for which you have just added the Module and Paste the Codes.
- This means if you have opened multiple workbooks along with the current one then the VBA script will work only for the active workbook. you need to add a separate module and paste the code again for each and every Open Workbook. Which can become a tedious task.
2. You should have Knowledge of Coding if you want to make changes to the output of this function.
3. You need to save your file as a Macro-enabled workbook.
- Which might not work on others' Computers if you shared with them.
The Other Way
Let's take the other method, where we accomplish this task by using the Add-Ins.
For this one also you need to download a file which you can get from this Link (NumbersToWords.xlam)
Then:
1. Press and Hold the Windows key and then press the R key on the keyboard.
- It will open your RUN prompt.
2. Type "%AppData%" and press ENTER.
- A window will appear.
3. Go to ROAMING Folder. If you are already in it then move to the next step.
4. Select MICROSOFT Folder.
5. Then Select ADDINS Folder.
6. Copy the "NumbersToWords.xlam" File you have downloaded from the above link and paste it into the ADDINS folder. Close the folder.
7. Now, Go to Microsoft Excel, select File in the ribbon Menu.
8. Choose OPTIONS.
- A pop-up window will appear.
9. In the pop-up window find Add-Ins and select it.
10. You can find "Numberstowords" into "Inactive Application Add-ins". Below all that you have an option of MANAGE and a drop-down list along with it.
11. In the drop-down list select "Excel Add-ins" and press GO next to it.
12. Another small pop-up window will appear to for tick selection. Tick the box in front of "Numberstowords" and press OK.
13. Open your desired workbook and in any CELL type "=spellnumber(CELL_WITH_AMOUNT)". Then press ENTER.
You will have your Amount written in Word Format. Alike VBA Script you don't have to add MODULE for every single workbook, till you have the Add-Ins File in Add-Ins Folder.
By using these two simple methods you can get your job done. If you will make any changes to the number or amount then the word value will automatically get updated. You don't have to type manually every time you make changes to the numbers or amount.
Limitations Of These Methods
Everything has its advantages and disadvantages so the limitations. The Limitation of these methods are:
1. You can only convert Numerical values up to 99,99,99,999.
2. If you share your workbook with the other person and if they don't have these Add-ins installed or have not enabled the Macro in their Excel workbook, and try to open the workbook, then it might show a "#Name?" error.
Solution To This Problem
We also have the solution to this problem, what you need to do is just share this article and help the other person setting-up their Excel workbook. So that person won't call you or bother you by asking that why the Excel Workbook shows the error you just shared with him?.
and you find yourself explaining the whole story or might tell him over the Phone Call or Chat how to get the thing done. Better share this post with them.