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 .

  1. 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!

5 ★ | 1 Vote

May be interested

  • Instructions to stamp negative numbers in ExcelInstructions to stamp negative numbers in Excel
    during the spreadsheet process on excel, we will have to work with many types of numbers, including negative numbers. and if you want to differentiate negative numbers from other numbers in the data sheet, you can format close or red brackets to distinguish them.
  • Instructions to change phone numbers associated with home bankingInstructions to change phone numbers associated with home banking
    currently, some banks have sent notices and support methods for you to update your phone number at home such as message confirmation, conversion via website system, applications, ...
  • 3 ways to convert time to decimal numbers in Excel and how to convert it back3 ways to convert time to decimal numbers in Excel and how to convert it back
    in this article, we will show you 3 ways to convert time to decimal numbers in excel and how to convert it back. please follow the following article to know how to do it in detail
  • How to Convert .numbers to .xls formatHow to Convert .numbers to .xls format
    today's tipsmake will show you how to convert apple numbers documents into microsoft excel (.xls) files on the icloud website, mac, windows computers and iphones.
  • How to convert numbers to dates in ExcelHow to convert numbers to dates in Excel
    converting digital data into dates in excel is a pretty useful trick for people who use this software. sometimes your date data cells are converted into digital data cells, then if you do not know how to turn it back into a date, please refer to the following tutorial tips of tipsmake.com .
  • PI (PI Function) in Excel - How to use PI numbers in ExcelPI (PI Function) in Excel - How to use PI numbers in Excel
    pi (pi function) in excel - how to use pi numbers in excel. pi number is a mathematical constant with an approximate value of 3,1415926535897 ... we can find pi numbers in many trigonometric and geometric formulas. especially the formulas related to circles, ellipses, and spheres:
  • Split numbers from strings in ExcelSplit numbers from strings in Excel
    in the process of working with excel, i have encountered some cases that require separating only the fraction in a given string, now this post shares with you how to do this. the following article details how to separate numbers from a given string in excel.
  • How to convert dots to commas in Excel on Windows 7How to convert dots to commas in Excel on Windows 7
    how to convert a dot to a comma in excel on windows 7. sometimes at work you want to display the numbers in the traditional form of vietnam: separate thousands ... with commas.
  • Zalo, Viber will automatically convert the subscription number from 11 numbers to 10 numbersZalo, Viber will automatically convert the subscription number from 11 numbers to 10 numbers
    users of zalo and viber will be supported to continue using the service completely automatically when the time of sim 11 to 10 numbers is implemented starting from 00:00 on september 15, 2018 instead of having to be updated again. phone number manually.
  • How to extract numbers or text from ExcelHow to extract numbers or text from Excel
    microsoft excel is great for working with both numbers and text, but if you use both in the same cell, you may have some difficulties. fortunately, you can extract numbers or text from cells to work with your data more efficiently.