Help

The Community will be temporarily unavailable starting on Friday February 28. We’ll be back as soon as we can! To learn more, check out our Announcements blog post.

How to convert a number to text?

2828 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é