How to convert a number to text?


#1

Hello Airtable Community !

How can we convert a number to a text , like this for exemple : 100 > one hundred
Didn’t find a topic about that…

Thank you for your time


#2

Hi Thomas,

If you would have a table with the words next to the number, you could look it up. But the big question is: how would you fill a table like that without manually entering every single value?

When you Google on “How to convert numbers to Words” you will find a lot of online solutions. They seem to derive their results from a formula.

When you look for a solution in Excel, Microsoft Support will tell you that there is no instant solution, but you can achieve it by writing VBA code. Here is a link that will show you how to do that.

After you get the results, you can paste them in Airtable in a table.

Regards,
André