Currency formatting

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?

Regards,
André

1 Like

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.