Specifying the amount in words in Excel

When working with financial documents, it is often required to indicate the amount not only as a number, but also in words. Of course, such an activity can take a lot of time, especially when it comes to more than one document. In addition, when writing amounts in words, grammatical errors are not ruled out, the search and elimination of which will also require additional labor. Fortunately, in Excel you can automate this process, and below we will look at exactly how to do this.

Content

NUM2TEXT special add-on

Excel does not provide any special tool that allows you to automatically translate numbers into the corresponding text values. However, a special add-on can help in this matter. NUM2TEXT, which works through a function.

The algorithm of actions is as follows:

  1. In the top line of the program window, click on the menu “file”.Specifying the amount in words in Excel
  2. Select an item from the list on the left “Parameters”.Specifying the amount in words in Excel
  3. In the program options that open, click on the section “Add-ons”. Click the button at the bottom of the window “Go” next to point “Control”, whose value should be set to “Excel add-ins”.Specifying the amount in words in Excel
  4. The add-ons window will appear on the screen, in which we press the button “Review”.Specifying the amount in words in Excel
  5. An overview window will open where we navigate to the folder containing the pre-downloaded add-on file “NUM2TEXT.xla”. Select it and click the button OK.Specifying the amount in words in ExcelNote: Unfortunately, there is no official site from which you can download the add-on, however, it is quite easy to find it on the Internet using a search engine. The main thing is to download the file from reliable sources, always with the extension “xla”. After downloading the file to your computer, it will not be superfluous to check it with an antivirus program.
  6. The system will return us to the previous window again, where we can notice that the newly added add-on has appeared in the list of add-ons. We put a checkmark in front of it (if for some reason this did not happen automatically), then click the button OK.Specifying the amount in words in Excel
  7. Now we need to make sure the add-on works. To do this, write a random number in any empty cell. After that, go to another free cell and press the button “Insert function” (fx) to the left of the formula bar.Specifying the amount in words in Excel
  8. In the insert function window, select a category “Full alphabetical list”, find the string “Suma in cuirsive”, click on it, then on the button OK.Specifying the amount in words in Excel
  9. A window will open with a single function argument − “Sum”. In the field for entering the value of the argument, we can write either a regular number or specify the address of the cell, which we print manually or select in the table by clicking on the desired element (at the same time, the cursor should be in the field for entering information). After the argument value is filled in, click OK.Specifying the amount in words in Excel
  10. In the cell with the function, the result was displayed as a sum in words, which was required.Specifying the amount in words in ExcelMoreover, if we change the number in the source cell referenced by the function, the value in the final cell will also change.Specifying the amount in words in Excel

Manual entry of a function formula

Experienced users quite often prefer to write the final formula in a cell instead of using a function insertion and then filling in its arguments in separate windows.

In this case, the formula looks like this:

=Amount_in words(Amount)

As an argument “Sum”, as we noted earlier, both a specific number and a reference to a cell can be indicated.

For example, here is what the final formula looks like with the number 21: =Сумма_прописью(21).

Specifying the amount in words in Excel

After it is typed in the desired cell, we just have to press Enterto get the result.

Specifying the amount in words in Excel

Or we can specify the address of the cell instead of a number: =Сумма_прописью(B3).

Specifying the amount in words in Excel

After pressing the key Enter we also get the result as a sum in words in the formula cell.

Specifying the amount in words in Excel

Conclusion

Despite the fact that by default Excel does not provide a function that allows you to convert a numeric value into an amount in words, however, you can perform this task in the program by installing a special add-in. This process does not take much time and does not require special user skills.

Leave a Reply