No need to search far and wide or employ intricate formulas to turn numbers into text in Excel. In this article, Mytour introduces you to a software for converting numbers to text in Excel. With this Excel tool, a few basic clicks are all you need to convert numbers to text in bulk, regardless of the Excel version, be it Excel 2007 to the latest Excel 2016.
Guide to converting numbers to text in Excel
1. Installing Vntools
Step 1: To convert numbers to words in Excel, we'll use a handy software called Vntools. First, download Vntools to your computer from this link.
Step 2: Next, choose the installation path for Vntools. If this step isn't crucial for you, you can leave it as the default and press next.
Step 3: Continue pressing next until you see the Install button. Click here to proceed with the Vntools installation.
Step 4: Vntools software installs quickly, so stay on the screen. After installation, press Finish to start using Vntools for converting numbers to words in Excel.
2. Converting Numbers to Words in Excel
Step 1: Even though you've installed Vntools, it won't work for converting numbers to words in Excel unless activated. Open any Excel file and choose File > then select Options.
Step 2: In the Excel Options section, navigate to Add-in and select Go.
Step 3: Click on the Browse section to locate the Vntools executable file that we installed earlier.
Step 4: Now, recall the path of the Vntools software you installed earlier. Inside, you'll find a file named Ufunctions.xlam. Open this file by clicking on it and then select OK.
Step 5: Immediately in the Add-ins section, a new line named NTD's Tools will appear. This is the software that helps us convert numbers to words in Excel. Simply check it and press OK. If it's already checked, just press OK to close this section.
Step 6: Now, in any Excel file, you'll notice a new menu bar called Vntools. Click on it, and you'll find the tool that assists you in converting numbers to words in Excel.
Step 7: If you're using Unicode font, leave it as it is; otherwise, switch to VNI and TCVN 3. Below, there are two sections to note. The cell to convert is where you input the value to change to words in Excel.
The remaining cell is where you'll find the result.
Step 8: Simply copy the address where the result will be displayed before converting numbers to words in Excel.
Step 9: Once you've made your selections, press VND to initiate the conversion. If it's not a currency unit, avoid clicking on use unit for VND function.
The result will appear as shown below after converting numbers to words in Excel. Of course, we didn't check use unit for VND function, so the result will include the currency unit.
Using VnTools is the quickest and simplest way to convert numbers to words in Excel. This Excel tool not only facilitates fast conversion but also works in reverse, supporting various currencies.
During the usage of VnTools on Excel, if you encounter any issues or compatibility errors while using VnTools on Excel, leave a message here. The Mytour admin team will assist you in resolving the problem.
