Home
» Wiki
»
Instructions to convert numbers into words in Excel with VnTools
Instructions to convert numbers into words in Excel with VnTools
Video Instructions to convert numbers into words in Excel with VnTools
Your work is often related to numbers, or specifically related to currency or payroll calculation, revenue and expenditure calculations, which can be very useful when converting words into numbers automatically. as well as minimize errors in the calculation process.
So today, Download.com.vn will introduce to readers how to convert numbers into words with vnTools on Excel 2003, Excel 2007, Excel 2010, Excel 2012 very detailed for you to easily apply to your spreadsheet:
Instructions to convert numbers into letters in Excel
If you want to convert numbers into words in Excel, you need to download vnTools (select the download link suitable for the version of Excel you are using to download). Then, install this software on your computer to support changing numbers into words, converting fonts and fonts. VnTools supports currencies such as coins, coins, dollars and cents.
Instructions for installing vnTools software:
After downloading, double click on the file vnTools.exe to install the software on your computer. Immediately after the vnTools Setup window appears, simply press Install, then wait a while to complete the installation of vnTools on the computer.
Steps to convert numbers to letters in Excel 2003:
Step 1: Open Excel 2003 , on the menu bar, click the Tools tab , select Add-Ins ...
Step 2: The Add-Ins window appears, click the Browse ... button to select the file you just installed on your computer.
Step 3: Browse window appears, navigate to the file path Ufunctions.xla that you just installed above, then click Open to open.
Step 4: Next tick the NTD's Tools section to activate this tool, then click OK . So A dd-in will appear on the Excel toolbar.
Step 5: Now click the icon to convert numbers into text on the toolbar, the window Number to Text will appear . By default vnTools will convert to Unicode charset , if you want to convert to VNI or TCVN 3 charset , you just need to tick. Here, you can also add options:
Add the word "dong" to the string.
Add the word "dollar" to the string.
Formula to convert numbers to letters in Excel:
= VND (number to be changed, true): Change the number to the word that has the word "dong" at the end.
= VND (number to be changed): Only convert numbers into words.
= USD (number to be changed, true): Change the number into English words with the word " Dollar".
= USD (number to be changed): Change the number into words in English.
Steps to convert numbers to letters in Excel 2007:
Step 1: Open Excel 2007 , on the main interface of the application, click the Microsoft Office icon in the top left corner of the screen, select Excel Options to set some options.
Step 2: The Excel Options window appears, click the Add-Ins tab in the left column of the screen. Then, look to the bottom right corner in the Manager section select Excel Add-Ins , then click Go ...
Step 3: Next, the Add-Ins window appears, click Browse ... to find the Ufunctions.xla file path, now follow the same steps from Excel 3's step 3.
Now you see the results: You type the number 4523 into cell C5, then put the mouse in cell C6 type the formula = VND (C5) on the formula bar, immediately you will see the line Four thousand five hundred two, three in cell C6.
Note: For Excel 2010 and 2013, do the same thing with Excel 2007.
So now, you can change any number into words, minimize work burden, help manipulate and use, as well as manage data and invoices more easily. If you do not like installing vnTools to avoid risks with external add-ons, you can refer to how to convert numbers to words using Excel's own formula. In addition, you can refer to the calculation of seniority on Excel spreadsheets that Download.com.vn has also introduced.