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
How to convert a number to text?
+3This topic has been closed for replies.
+18Hi 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é
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.