Instructions for converting numbers to words in Excel

The operation of converting numbers to words in Excel is certainly very familiar to those who often have to make statistical and accounting tables. 

1. How to convert numbers to words in Excel using vnTools

Step 1:

First, we download the vnTools software to our computer using the link below and then install it on our computer as usual.

Instructions for converting numbers to words in Excel Picture 1

Step 2:

After you have installed the software, open Excel, click on File in the top left corner of the screen.

Instructions for converting numbers to words in Excel Picture 2

Step 3:

Next you will click on Options to open the list of customizations for Excel.

Instructions for converting numbers to words in Excel Picture 3

In the list of customizations, we click on Add-ins . Looking at the content next to it, in the Manage section , we will click on Go…

Instructions for converting numbers to words in Excel Picture 4

Step 4:

Now the Add-Ins window interface appears, we will click Browse .

Instructions for converting numbers to words in Excel Picture 5

Step 5:

Go to the vnTools software folder, select the Ufunctions file , then click OK.

Instructions for converting numbers to words in Excel Picture 6

Now you will see the Ufunctions add-ins . We will select it and then click OK to use this add-ins in Excel.

Instructions for converting numbers to words in Excel Picture 7

Step 6:

Return to the Excel interface, click on the vnTools tool you just added, then look down and click on Convert numbers to words .

Instructions for converting numbers to words in Excel Picture 8

Then the table will be displayed for us to select the content to convert. In the cell to be converted, you will click on the cell containing the numeric value to be converted to text and the cell containing the result is the cell containing the result after translating from number to text .

After entering, press VND to convert numbers to words.

Instructions for converting numbers to words in Excel Picture 9

The result we get is the number converted to words as shown below.

Instructions for converting numbers to words in Excel Picture 10

How to convert numbers to words in Excel using the =VND function

Step 1:

First, download the Excel file from the link below to your computer as usual.

Step 2:

Open Excel, click Options, then select Add-Ins. Next, look at the content next to it, click Add-Ins. Next, look at the content next to it, at Manage, select Go…

Instructions for converting numbers to words in Excel Picture 11

Step 3:

A new window interface appears, click Browse to upload the add-ins file . We will click on the Doiso file .

Instructions for converting numbers to words in Excel Picture 12

Now click on the Doiso file in the Add-Ins window and click OK.

Instructions for converting numbers to words in Excel Picture 13

Step 4:

After adding Add-Ins, enter the following function to convert numbers to money: Function syntax: =VND(Number_to_convert) .

Instructions for converting numbers to words in Excel Picture 14

Then you also get the amount in words as shown below.

Instructions for converting numbers to words in Excel Picture 15

Instructions to convert numbers to words in Excel without add-ins

There is also another way for you to convert numbers to words without using add-ins. You follow the detailed instructions in the article below.

Marvin Fry

Update 06 September 2024