“Amount in Words” for your bank check using Google Sheets

Here, we will create a custom function, using Google Apps Script, that we can use in our Google Sheets.

In Google Sheets, click Extensions > Apps Script.

You will see a screen like this. This is a Code.gs file where we can put Apps Script codes.

Go to this Github link. You will see a Code.gs file there. Copy the codes in that file and replace everything in your Code.gs.

Your Code.gs file will now look something like this.

Click save.

Back to Google Sheets, you can now use the function AMT2WORDS which would convert an amount (or number) to words (just like in a bank check).