Skip to main content

How to convert a number to text?

  • October 23, 2018
  • 1 reply
  • 25 views

Forum|alt.badge.img+3

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

This topic has been closed for replies.

1 reply

Forum|alt.badge.img+18

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é