Skip to main content

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:



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




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?

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.

Write 53,078,064 out in words

There are tons of JavaScript packages available online that translate numbers into words. 

if you are looking for a readymade solution for number conversion you can use an online number to word converter 

and for for development in Javascript you can use the npm package to words or 

 

Reply


Terms & Conditions