Forum Discussion
Convert Number to Words LAMBDA (Very Large Numbers)
I created this LAMBDA Function "Number_To_Words" in order to convert Numbers to Words (eg. 2813 can be written as Two Thousand Eight Hundred Thirteen in words) First Parameter of the function is ...
Someone suggested to use BAHTTEXT() and TRANSLATE() (so far only on Beta), it looks like
=SUBSTITUTE( SUBSTITUTE( SUBSTITUTE( TRANSLATE(BAHTTEXT(F11)), "baht", "Dollar" ), "satang", "cent" ), ".", " only" )
I did think of using it, but rejected it because (1) it requires an online connection, (2) it doesn't respect singular/plural forms for currency, (3) it gives inconsistent cases that throws off SUBSTITUTE - for example, 10 and 100,000 renders as "Baht", but 100, 1,000 and 10,000 renders as "baht", (4) the translation isn't perfect - for example, 11,112,222 is rendered as "eleven million, one hundred and eleven, twelve thousand, two hundred and twenty-two dollar only", and (5) it doesn't handle billions well 😅