Converting Numbers into Words

[Hady_Abdelnour]

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

[Bill_French]

Hady_Abdelnour:

There were some extremely complicated formulas that simply didn’t work the way they should and there are no scripts.

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.

Formula for Number to Text Ask the community

There’s not an easy way to do this. I’m sure it’s possible with a gigantic nested conditional formula, but that’s going to be a pain to write. If you’re interested in trying, you’ll probably be making use of: SUBSTITUTE({Field with Number}, "1", "one ") <-- For each digit 1-9 I would have 10 different fields for this, each one taking the output of the one before it and converting its assigned digit to the word representing that digit. Next, you’d probably want to figure out the base10 thousa…

[ScottWorld]

Hady_Abdelnour:

there are no scripts

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

stackoverflow.com

Convert digits into words with JavaScript

javascript

asked by Jeo on 06:29AM - 08 Feb 13 UTC

[Hady_Abdelnour]

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

stackoverflow.com

Convert digits into words with JavaScript

javascript

asked by Jeo on 06:29AM - 08 Feb 13 UTC

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?

[Bill_French]

Hady_Abdelnour:

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.