How to convert numbers into words in Excel?
In Excel, entering and typing amounts is very tiring, sometimes confusing. So why do this work faster but still have to ensure accuracy? TipsMake.com will introduce you to a support tool, or more accurately, an additional add-in for Microsoft Excel, very convenient for accounting, finance, people who have to work with big amounts .
- Download VnTools add-in to your computer
How to use vnTools:
After downloading vnTools successfully, you unzip the folder (anywhere), open Microsoft Excel and then select File> Options :
How to convert numbers into words in Excel? Picture 1
At the Options panel> we select Add-Ins > choose Excel Add-Ins in the Manage section and click Go :
How to convert numbers into words in Excel? Picture 2
The Add-Ins management panel appears> click Browse, select the add-in file (with the * .xla extension) and then OK:
How to convert numbers into words in Excel? Picture 3
When the "installation" is successful, the add-in will appear on the corresponding tab as shown below:
How to convert numbers into words in Excel? Picture 4
And now you want to convert the number into words, you just need to select the number box (enter the cell to convert , as the example here is cell B11) and then select the cell containing the result , here is B12, select the unit to display market is VND or USD depending on you:
How to convert numbers into words in Excel? Picture 5
And this is our result:
How to convert numbers into words in Excel? Picture 6
So with add-in vnTools, we will save a lot of time when working with long numbers. This tool is compatible with many Microsoft Excel versions from 2003 to 2010, can handle up to 15 numbers, well supported Vietnamese encoding, VNI and TCVN3.Good luck!
You should read it
- How to convert money into words in Excel, without an add-in, supports both 32-bit and 64-bit Excel
- Convert numbers to text in Excel
- How to convert Apple Numbers documents to Microsoft Excel
- Simple way to convert Excel files to PDF
- How to convert a sequence of numbers into dates in Excel
- Instructions to stamp negative numbers in Excel
- How to convert negative numbers to positive numbers Excel
- How to convert numbers into text in Excel is great
- How to extract numbers or text from Excel
- How to Convert .Numbers to .Xls
- How to read the amount in words in Excel
- How to convert Excel files to PDF online using Google Drive
May be interested
Summary of shortcuts for Microsoft Excel 2016-P2
Download and try Office 2013 Professional Plus for free for 60 days
Fix Outlook and Office 365 errors with just one click
Download and install or reinstall Office 365, Office 2016, Office 2013 on your computer
Create and share office documents on Facebook with Docs
How to install Vietnamese interface for Microsoft Office 2010