
- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Oct 23, 2018 03:44 AM
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

- Mark as New
- Bookmark
- Subscribe
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Oct 24, 2018 09:49 AM
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é
