Some office PCs are locked down hard: macros disabled by policy, add-ins forbidden, and the red bar wins every argument. If that is your machine, the VBA route is closed - but the job still has to be done. Plain formulas, arranged in helper columns, can do it.
Set your expectations honestly first: this is the workshop method, not the elegant one. It converts amounts up to 99,999, in plain words, with no Rupees or Paise. Within those limits it is dependable, it runs anywhere - including Google Sheets - and every formula below is copy-paste ready.
Example values - the machine takes the number apart in columns, words each piece, then joins them. No macro anywhere.
Plain formulas can build words, but they do it the hard way: a formula has no memory and no loops, so you must cut the number into pieces in helper columns and word each piece separately. That works cleanly up to 99,999. Beyond that, pieces multiply and the sheet becomes a machine nobody in your office can repair.
It also speaks plain number words only - no Rupees, no Paise, and zero comes out blank. If those limits fit your job - a locked office PC where macros are banned is the classic case - this route is real and it works. If they do not fit, the VBA function from the main guide is simply the better tool, and no amount of formula cleverness changes that.
Put your amount in A2. Then three helper columns do the cutting:
=INT(A2/1000) - for 4732 this gives 4=INT(MOD(A2,1000)/100) - this gives 7=MOD(A2,100) - this gives 32Every amount up to 99,999 is exactly these three pieces: a two-digit thousands chunk, one hundreds digit, and a two-digit tail.
One formula pattern words any two-digit piece. In C2, for the thousands chunk in B2, paste this exactly:
{CHUNK_B}
In E2, the hundreds word from D2:
=IF(D2=0,"",INDEX({"One","Two","Three","Four","Five","Six","Seven","Eight","Nine"},D2)&" Hundred ")
And in G2, the same two-digit pattern once more, this time for the tail in F2:
{CHUNK_F}
How the pattern works: numbers under 20 are irregular in English, so they are looked up directly from the list. Above 20, it takes the tens word and joins the ones word - which is why Forty Seven comes out right, and why the same one formula serves both two-digit pieces.
One last formula assembles the sentence. Thousands words are in C2, hundreds words in E2, tail words in G2 - so in H2:
=TRIM(IF(B2>0,C2&" Thousand ","")&E2&G2)
TRIM tidies the spaces where a piece was empty - an amount like 61000 has no hundreds and no tail, and still reads cleanly as Sixty One Thousand.
Fill every formula down beside your amount list and the whole column converts at once. And respect the boundary: type 100000 and the sheet answers with an error, loudly - the pieces no longer fit. That loud failure is a feature. The day your amounts pass 99,999, move to the VBA route rather than stretching this one.
See the file downloaded, the add-in switched on and the formula typed live - the complete method in about a minute.
Watch Full VideoSingle-cell versions do exist, but they are hundreds of characters of nested logic that nobody can read, test or repair - and when one breaks, it tends to break quietly, printing wrong words on real documents. Helper columns keep every piece visible: if the thousands word is wrong, you can see exactly which column produced it.
No. It converts whole numbers only, and it drops the decimal part silently rather than warning you. If your amounts carry paise, that silence is dangerous - use the VBA function from the main guide, which reads paise properly, or round your amounts deliberately before converting them here.
Yes. INT, MOD, INDEX, IF and TRIM behave the same way in Google Sheets, and the word lists in curly brackets work there too. That is the one real advantage of this route: the file converts amounts on machines where no macro will ever be allowed to run.