Help

Possible to convert a string into a decimal

9225 5
cancel
Showing results for 
Search instead for 
Did you mean: 

I’m trying to make a column show different currencies.
I’ve got a column for price and a column for € price and formula field that is controlled by a 'currency switch' which determines if the price in the formula field is shown in or €.
My problem is I need to multiply the formula field with another field but it’s now a string as it has either a $ or a € attached to it.
Is it possible to take and convert the numbers in the string back into a decimal?

5 Replies 5

Yes it is:

image.png

Sorry about that question - completely did not look the most obvious place of all for an answer.
But thank you for flagging it.

No need to apologize – it’s not entirely clear what exactly you would enter as a search term to find that answer easily in the support docs anyways.

I searched for “Convert text to number”, and the answer only showed up as the 3rd option in the list, and even then you have to read the subtext carefully to catch it:
image

Happy to help by pointing people to the right place in the support docs.

Mark_Dixon
6 - Interface Innovator
6 - Interface Innovator

This rounds decimals. i.e. VALUE(“123.45”) =>123

Ambroise_Dhenai
8 - Airtable Astronomer
8 - Airtable Astronomer

Note that it also cannot deal with too big numbers. For instance, VALUE('30006000011234567890189152776') returns 3.

This isn’t specified anywhere, surprise.

That makes it impossible to use Airtable formula to check if an IBAN is correct, because the IBAN specification relies on doing a modulo by 97, as per International Bank Account Number - Wikipedia Validating the IBAN.

But it’s impossible to convert such a big number from string to number.