Help

How to convert a number to text?

2669 1
cancel
Showing results for 
Search instead for 
Did you mean: 
thomas_kochansk
4 - Data Explorer
4 - Data Explorer

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

1 Reply 1

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.

https://www.extendoffice.com/documents/excel/1446-excel-convert-change-numbers-to-words.html

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

Regards,
André