Converting Numbers into Words

Hey Lovely People,

I have been searching endlessly on Airtable community for a formula that helps convert numbers into texts (such as 1,555 into one thousand, five hundred and fifty five).

There were some extremely complicated formulas that simply didn’t work the way they should and there are no scripts. I wish I was a developer to do one. Is there someone out there interested in helping creating such a script? Please note that I need them more than 9,999 (meaning I have some numbers in millions as well).

Best,
Hady

To the contrary…

Asked and answered in far greater detail than one could ever hope! Pay close attention to this message and this one by @Liz_Treacy.

The Internet is filled with tons of JavaScripts that convert numbers into words. This thread alone contains 3 different scripts:

1 Like

Hey Thanks for this. Can you help me with this, If I use this code:


How do I tell my app which one is the column that s the feeding the numbers and which one is the column that s the taking the letters?

Here’s a working Script Block example.