Amount in words is the line an accountant is judged by. It sits on every invoice and every cheque, banks read it before the figures, and it has one job: to say exactly the same thing as the number next to it - in Rupees, in Paise, and closed with the word Only.
The function from the main guide already speaks proper money language. This page explains what each part of the wording means, the one rounding trap that makes words and figures quietly disagree, and how the same discipline applies when you write a cheque by hand.
Example invoice - the words are generated from the same total cell as the figures, so the two can never drift apart.
On a cheque, the bank reads the words first. On an invoice, the words are the amount your customer can challenge. If figures say 12,340 and words say Twelve Thousand Three Hundred, the document is defective - cheques get returned for exactly this mismatch, and invoice disputes start from smaller things.
That is the real reason to generate the words with a function from the same cell as the total: a human typing words can slip; a function reading the total cannot disagree with it.
The code in this series ends every amount the way Indian money documents expect:
Point the function at the total with =SpellNumber(A10), replacing A10 with your own total cell.
Tax invoices carry decimals everywhere - item rates, GST, round-offs. The function reads paise from the first two decimal digits, so a total of 12340.505 sitting in the cell would speak Forty Paise where your printed figure shows 12340.51 after display rounding. The words and the figures would quietly disagree.
Convert the rounded value instead:
=SpellNumber(ROUND(A10, 2))
Now the function sees exactly the amount the invoice shows. If your invoices always settle to whole rupees, =SpellNumber(ROUND(A10, 0)) drops the paise entirely and the line ends in Rupees Only, every time.
The function teaches the correct habit even when you pick up a pen:
See the file downloaded, the add-in switched on and the formula typed live - the complete method in about a minute.
Watch Full VideoOnly is the closing word of the amount, not a note about paise. It tells every reader the amount ends here and nothing more can be added to the line. A whole amount correctly ends as Rupees Only - removing it would make the wording less safe, not more correct.
Almost always a rounding gap: the cell holds more decimals than the invoice displays, and the function reads the first two decimal digits of the real value. Wrap the total as =SpellNumber(ROUND(A10, 2)) so the function converts exactly the amount the document shows.
You can - the currency words live in the Select Case lines near the end of the code, and many offices edit them, for example to write INR or to drop Paise on whole-rupee documents. Edit a copy, test it on 1000 and on 1234.56, and only then put it in the live file.