Skip to main content

Currency formatting

  • November 15, 2019
  • 3 replies
  • 48 views
A
Forum|alt.badge.img+18

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é

3 replies

Justin_Barrett
Forum|alt.badge.img+21
  • Justin_Barrett
  • Inspiring
  • 4647 replies
  • November 28, 2019

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.

V
Forum|alt.badge.img

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

kauelima
Forum|alt.badge.img+1
  • kauelima
  • New Participant
  • 1 reply
  • April 5, 2023

+1 on that, i'm trying to make some expense tracker on airtable but currency formatting makes it very difficult. Not only it formats the display but it also blocks copy/paste with the correct format for my location. I would be ok with a visual wrong formatting but the copy/paste is a real problem


Terms & ConditionsAccessibility statement