Example:

value desired output
300 Three Hundred
300000 Three Lakhs
3333333 Thirty Three Lakhs Thirty Three Thousand Three Hundred and Thirty Three

I can’t find a way to do this in Google Sheets. I found a solution here in this link: Convert numbers in Google Sheets to Text / Words which uses Array formula as well. However, the metric system used is millions and billions and I need the Indian system which is of Lakhs and Crores. And I would like to use the Array function along with it.

I tried the NUMBERTEXT function but it doesn’t work with Array formula and my document takes forever to load if I apply only NUMBERTEXT to all cells.

Can someone please help.

Currently I am using this formula but as you can see it is in millions and trillions:

=ArrayFormula(proper(if(A1:A=””,””,if(len(int(A1:A))<13,””,if(right(left(int(A1:A),len(int(A1:A))-12),3)+0>99,choose(left(right(left(int(A1:A),len(int(A1:A))-12),3))+0,”one”,”two”,”three”,”four”,”five”,”six”,”seven”,”eight”,”nine”)&” hundred “,)&if(right(right(left(int(A1:A),len(int(A1:A))-12),3),2)*1>19,choose(left(right(right(left(int(A1:A),len(int(A1:A))-12),3),2))-1,”twenty”,”thirty”,”forty”,”fifty”,”sixty”,”seventy”,”eighty”,”ninety”)&choose(right(right(left(int(A1:A),len(int(A1:A))-12),3))+1,””,” one”,” two”,” three”,” four”,” five”,” six”,” seven”,” eight”,” nine”),choose(right(right(left(int(A1:A),len(int(A1:A))-12),3),2)+1,””,”one”,”two”,”three”,”four”,”five”,”six”,”seven”,”eight”,”nine”,”ten”,”eleven”,”twelve”,”thirteen”,”fourteen”,”fifteen”,”sixteen”,”seventeen”,”eighteen”,”nineteen”))&” trillion”)&” “&if(len(int(A1:A))<10,””,if(right(left(int(A1:A),len(int(A1:A))-9),3)+0>99,choose(left(right(left(int(A1:A),len(int(A1:A))-9),3))+0,”one”,”two”,”three”,”four”,”five”,”six”,”seven”,”eight”,”nine”)&” hundred “,)&if(right(right(left(int(A1:A),len(int(A1:A))-9),3),2)*1>19,choose(left(right(right(left(int(A1:A),len(int(A1:A))-9),3),2))-1,”twenty”,”thirty”,”forty”,”fifty”,”sixty”,”seventy”,”eighty”,”ninety”)&choose(right(right(left(int(A1:A),len(int(A1:A))-9),3))+1,””,” one”,” two”,” three”,” four”,” five”,” six”,” seven”,” eight”,” nine”),choose(right(right(left(int(A1:A),len(int(A1:A))-9),3),2)+1,””,”one”,”two”,”three”,”four”,”five”,”six”,”seven”,”eight”,”nine”,”ten”,”eleven”,”twelve”,”thirteen”,”fourteen”,”fifteen”,”sixteen”,”seventeen”,”eighteen”,”nineteen”))&” billion”)&” “&if(len(int(A1:A))<7,””,if(right(left(int(A1:A),len(int(A1:A))-6),3)+0>99,choose(left(right(left(int(A1:A),len(int(A1:A))-6),3))+0,”one”,”two”,”three”,”four”,”five”,”six”,”seven”,”eight”,”nine”)&” hundred “,)&if(right(right(left(int(A1:A),len(int(A1:A))-6),3),2)*1>19,choose(left(right(right(left(int(A1:A),len(int(A1:A))-6),3),2))-1,”twenty”,”thirty”,”forty”,”fifty”,”sixty”,”seventy”,”eighty”,”ninety”)&choose(right(right(left(int(A1:A),len(int(A1:A))-6),3))+1,””,” one”,” two”,” three”,” four”,” five”,” six”,” seven”,” eight”,” nine”),choose(right(right(left(int(A1:A),len(int(A1:A))-6),3),2)+1,””,”one”,”two”,”three”,”four”,”five”,”six”,”seven”,”eight”,”nine”,”ten”,”eleven”,”twelve”,”thirteen”,”fourteen”,”fifteen”,”sixteen”,”seventeen”,”eighteen”,”nineteen”))&” million”)&” “&if(len(int(A1:A))<4,””,if(right(left(int(A1:A),len(int(A1:A))-3),3)+0>99,choose(left(right(left(int(A1:A),len(int(A1:A))-3),3))+0,”one”,”two”,”three”,”four”,”five”,”six”,”seven”,”eight”,”nine”)&” hundred “,)&if(right(right(left(int(A1:A),len(int(A1:A))-3),3),2)*1>19,choose(left(right(right(left(int(A1:A),len(int(A1:A))-3),3),2))-1,”twenty”,”thirty”,”forty”,”fifty”,”sixty”,”seventy”,”eighty”,”ninety”)&choose(right(right(left(int(A1:A),len(int(A1:A))-3),3))+1,””,” one”,” two”,” three”,” four”,” five”,” six”,” seven”,” eight”,” nine”),choose(right(right(left(int(A1:A),len(int(A1:A))-3),3),2)+1,””,”one”,”two”,”three”,”four”,”five”,”six”,”seven”,”eight”,”nine”,”ten”,”eleven”,”twelve”,”thirteen”,”fourteen”,”fifteen”,”sixteen”,”seventeen”,”eighteen”,”nineteen”))&” thousand”)&” “&if(len(int(A1:A))<1,””,if(right(left(int(A1:A),len(int(A1:A))-0),3)+0>99,choose(left(right(left(int(A1:A),len(int(A1:A))-0),3))+0,”one”,”two”,”three”,”four”,”five”,”six”,”seven”,”eight”,”nine”)&” hundred “,)&if(right(right(left(int(A1:A),len(int(A1:A))-0),3),2)*1>19,choose(left(right(right(left(int(A1:A),len(int(A1:A))-0),3),2))-1,”twenty”,”thirty”,”forty”,”fifty”,”sixty”,”seventy”,”eighty”,”ninety”)&choose(right(right(left(int(A1:A),len(int(A1:A))-0),3))+1,””,” one”,” two”,” three”,” four”,” five”,” six”,” seven”,” eight”,” nine”),choose(right(right(left(int(A1:A),len(int(A1:A))-0),3),2)+1,””,”one”,”two”,”three”,”four”,”five”,”six”,”seven”,”eight”,”nine”,”ten”,”eleven”,”twelve”,”thirteen”,”fourteen”,”fifteen”,”sixteen”,”seventeen”,”eighteen”,”nineteen”)))&if(int(A1:A)=0,””,if(int(A1:A)<2,””,””))&iferror(“”&if(round(mod(A1:A,1)*100,2)>19,choose(left(mod(A1:A,1)*100)-1,”twenty”,”thirty”,”forty”,”fifty”,”sixty”,”seventy”,”eighty”,”ninety”)&choose(right(round(mod(A1:A,1)*100,2))+1,””,” one”,” two”,” three”,” four”,” five”,” six”,” seven”,” eight”,” nine”),choose(round(mod(A1:A,1)*100,2)+1,””,”one”,”two”,”three”,”four”,”five”,”six”,”seven”,”eight”,”nine”,”ten”,”eleven”,”twelve”,”thirteen”,”fourteen”,”fifteen”,”sixteen”,”seventeen”,”eighteen”,”nineteen”))&””))))