Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Currency formatting

Topic Labels: Formulas
1592 2
Showing results for 
Search instead for 
Did you mean: 

Hi everyone,

I would love to have an permanent - Airtable - solution for this problem: the standard Currency format is the US format. Meaning: the COMMA for the thousands and the DOT for smaller figures (lower than $1, for example: $15,388.99). I am from the Netherlands and our system is the other way around. We use the DOT for the thousands, and the COMMA for the smaller figures (€ 15.388,99).

What would be the best workaround as long as Airtable does not give me the pick my Netherlands format?


2 Replies 2

Perhaps some variation on these “pretty print” routines will help:

You could take the existing output from those formulas and run a series of SUBSTITUTE() functions on it to swap the separators.

It is impossible to work with other currencies. Create support for alternative currency format (with comma) please.