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 :
At the Options panel> we select Add-Ins > choose Excel Add-Ins in the Manage section and click Go :
The Add-Ins management panel appears> click Browse, select the add-in file (with the * .xla extension) and then OK:
When the "installation" is successful, the add-in will appear on the corresponding tab as shown below:
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:
And this is our result:
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 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
May be interested
- Summary of shortcuts for Microsoft Excel 2016-P2while performing spreadsheet operations, if you know some of the shortcuts will save you time, the process will be greatly shortened.
- Download and try Office 2013 Professional Plus for free for 60 daysmicrosoft office professional plus 2013 includes all the tools word, powerpoint, excel, outlook, onenote, access, publisher and lync. microsoft allows users to try the free 60-day version to experience all the features available in the paid version.
- Fix Outlook and Office 365 errors with just one clickif you experience any issues or problems in outlook and office 365, you can use the microsoft support and recovery assistant tool for office 365 to fix and resolve issues quickly.
- Download and install or reinstall Office 365, Office 2016, Office 2013 on your computerto install office 365 home, personal or university versions or a paid version of office 2016 or office 2013 on a computer (laptop, pc) and how to fix some errors during office. please refer to the following article of network administrator.
- Create and share office documents on Facebook with Docsdocs provides an online microsoft office 2010 platform, enabling you to quickly create and share office documents with friends on facebook.
- How to install Vietnamese interface for Microsoft Office 2010almost every set that installs microsoft office is in english language. therefore, it makes it difficult for many people who are not fluent in this language, leading to slow, wrong and affecting work performance. the best way is to switch to vietnamese language interface by ...