Your claim is pretty weird. There are no other countries on the globe of America.

Lol, this is so true!

+1. Other formats like ###.###,00 me too please!

Please be sure to email support@airtable.com with your requests for this feature, too!

As a team that is 100% USA-based, they are apparently unaware of other countries! :man_shrugging:t2: :winking_face:

So? What needs to be done for this to happen???

Still no? Whyyyyy?

This is still not a feature? My mind is blown.

They rarely listen to us. We’re just chatting amongst ourselves here. And they think that there’s only one country in the world: USA.

They don’t realize that 50% of the countries around the world use different currency formatting. (Partial list of countries on that page.)

Best thing you can do is email support@airtable.com, and hope that enough people request this for them to finally change it within the next decade or so. :roll_eyes:

I would like to know the possibility of changing the separation of thousands with a comma, and place it with a period. (Current: 1,000) (I need: 1,000)

me gustaría saber la posibilidad de cambiar la separación de miles con coma, y colocarla con punto. (Acutal: 1,000) (Necesito: 1.000)

Really do need this!!!

However, I just discovered that the currency formula works, just leave the symbol box empty when formatting.

4 years later, still waiting…

Such a silly workaround, but completely solved the issue I was having. Thanks so much.

I found a workaround which does the job, however I do agree with all of you that “.” instead of “,” separators should be a common feature. This works for numbers from 1 to 999.999.999 without commas.

Let’s assume you have a column “ColumnA” which contains the number 264,984,354

Step 1

Create a support column “ColumnB” as formula type column, use the formula

CONCATENATE({ColumnA})

to convert it to a string

Step 2

Create another column as formula type column, use the formula

IF(LEN({ColumnB})<=3,{ColumnB},IF(LEN({ColumnB})<=6,CONCATENATE(LEFT({ColumnB},LEN({ColumnB})-3),".",MID({ColumnB},LEN({ColumnB})-2,3)),CONCATENATE(LEFT({ColumnB},LEN({ColumnB})-6),".",MID({ColumnB},LEN({ColumnB})-5,3),".",MID({ColumnB},LEN({ColumnB})-2,3))))

to change the number format to 264.984.354

Feel free to add a working comma-function and paste it here, I’m sure others would appreciate it.

need this please Airtable

Be sure to email support@airtable.com about this.

Nobody in Europe (and 80% of the world that doesn’t use USA formatting) can use the product because of this.

Please Airtable, that is a feature we miss a lot from converting from our Google spreadsheets

Another hand up from me to make this a feature!

PLEASE add this… why is this not a feature yet? Very disappointing & makes our data hard to read!

Thanks so much, worked perfectly!

Thanks Josh, for additional thousand separators this workarround is fine. Still not working for folks, who wants to have something like this: 12.549,12 instead of 12,549.12

=> Ninox does all this stuff

Absolutely shocked that this was not a day-one feature. This is NEEDED!

I’m glad I’m finding out how AirTable runs their dev and support during my evaluation. I really don’t think this is going to be a good solution.

Thank you, Johannes! This was extremely close to what I was looking for. I wanted to improve the appearance of the Market Cap and 24hr Volume in my Crypto Portfolio. I use the CoinMarketCap API to import current values into my table, but the numbers are so huge it is almost impossible to read them. I modified your formula a bit to fit my situation and it worked beautifully. I will leave a reference of my work for the Market Cap field here in case anyone else is looking for a way to abbreviate long financial based numbers.

As you can see, the {USD.market_cap} field is a very long number set to the maximum decimal places. I used three separate formula fields to come to my final Market Cap field.

Step 1

Create a new formula type field. Mine is titled “mc_1”. Use a formula to reference back to your large number field to remove all places after the decimal. My large number field is titled “USD.market_cap”.

ROUND({USD.market_cap},0)

Step 2

Create a second formula type field. Mine is titled “mc_2”. This time your formula will create a string from your number in your first reference field.

CONCATENATE(mc_1)

Step 3

Create one last formula field. Mine is titled “Market Cap”. This will be the one that tidies up the long string of numbers. It will reference both of the previous fields you just made. Be sure to reference the field from Step 2 for the (LEN) portion of your formula, and to reference the field from Step 1 for the mathematical portion of your formula.

IF(LEN(mc_2)>=10,"$"&ROUND(mc_1/1000000000,1)&" B",IF(LEN(mc_2)>=7,"$"&ROUND(mc_1/1000000,1)&" M",IF(LEN(mc_2)>=4,"$"&ROUND(mc_1/1000,1)&" K","$"&ROUND(mc_1,1))))

Or, if your numbers go into the trillions, go one more step…

IF(LEN(mc_2)>=13,"$"&ROUND(mc_1/1000000000000,1)&" T",IF(LEN(mc_2)>=10,"$"&ROUND(mc_1/1000000000,1)&" B",IF(LEN(mc_2)>=7,"$"&ROUND(mc_1/1000000,1)&" M",IF(LEN(mc_2)>=4,"$"&ROUND(mc_1/1000,1)&" K","$"&ROUND(mc_1,1)))))

+1. Other formats like ###.###,00 me too please!

Seriously – really just needed to do a good old fashioned left-padded ID number, being able to format with a specification of “00000” would have made it work a lot, lot cleaner.

Coming late to this party - no comma separated numbers for financial reporting? Airtable you are just awesome - but??