How To Convert Amount To Words In Excel

Hello there!

In this tutorial, I am going to show you a Visual Basic Script for converting amount to words in excel.

Prerequisites:

    - The reader is expected to know how to use Excel VBA (Visual Basic for Applications) in order to follow the following instructions.

1. First, open your excel application

2. Navigate to the VBA by pressing Alt+F11
(This is pressing they 'Alt' key together with 'F11' key).

3. From there, create a new module on the left pane by right-clicking on the VBA Project empty area, select Insert>Module.

4. Paste the below code on the code window.

5. Save the file as '.xls' or '.xlsm'. The first file format is for Excel 97-2003 and the latter if for the newer version of excel which means Macro-Enabled.

     Note: You may notice that the currency I used is 'Peso', just replace it in the code for your preferences..

6. After that, we can now start using our function.

7. To use the function, select the cell where you want the converted amount to be displayed and input the following formula:

    =AmountToWords(number)

The 'number' attribute is the number you want to convert to words.

I hope this helps as it does on my colleagues. Thanks and enjoy...