New formatting options for number fields

Showing results for 
Search instead for 
Did you mean: 
Airtable Employee
Airtable Employee

Hi Airtable Community! I'm Matt, a Software Engineer here at Airtable. We're excited to announce some new features of number fields that give you more control over how numeric data is formatted and abbreviated. To access these updates, create a Number field or configure an existing Number field.


What's included in these updates?

Format numbers for different languages. Using the new “Thousands and decimal separators” setting, you can format numbers automatically based on users' language preferences with the new “Local” option. For example, an English-speaking user sees 1,234.0 while a German-speaking user sees 1.234,0. You can also choose a specific format that applies to all users regardless of language preferences. Support for additional languages and regions will be available over the coming weeks.

Control whether thousands separators are shown. You can choose to display a number or currency field with thousands separators (1,234,567.0) or without (1234567.0).

Abbreviate large numbers. If you have large numbers or currency values, you can display them as an abbreviated value. For example, $34.1M instead of $34,100,000. When editing this value or referencing it in a Formula or in filters, we’ll continue to use the underlying, unabbreviated value.

Preview the result of a field’s settings. As you try out different combinations of options, we’ll show an example value to make it easier to confirm your selection before saving the field configuration.

Separator formats.png

What field types support these new settings?

Thousands and decimal separator customization is available for Number, Currency, Percent, and Duration fields, as well as computed fields (Formula, Lookup, Rollup) that are formatted as a Number, Currency, Percent, or Duration.

Large number abbreviations are available for Number and Currency fields, as well as computed fields (Formula, Lookup, Rollup) that are formatted as a Number or Currency.

12 - Earth
12 - Earth

Finally! More of this kind of updates please! Progress bar update was also 🔥. Maybe the American "phone" field could be next, so you could set your own phone structure? With or without the "+xx" as prefix for example. 

5 - Automation Enthusiast
5 - Automation Enthusiast

This is an important improvement, but there are still dangerous conversations out there.Bildschirmfoto 2023-10-11 um 12.07.30.jpg

18 - Pluto
18 - Pluto


The large number abbreviation option seems to only let us choose ONE of the 3 options. It would be great if we could select more than one of the abbreviation options. 

4 - Data Explorer
4 - Data Explorer

Thanks for these improvements!

After setting my language to French, I still have a dot for decimal and no separator for thousands, instead of comma separator for decimals, and space separator for thousands.

4 - Data Explorer
4 - Data Explorer

@Matt_Bush Hi Matt.  This has been a great update to some of the elements that we use in our Interfaces, however the formatting doesn't seem to carry through to all elements.  As an example, a number updated to show as "35.1M" will be presented in that format in a number element, but when the same value is added to a chart it shows as "35,102,036.36" as if it has not been formatted in the Data.  Will there be an additional roll out that will include this formatting update in other elements within the Interface?

4 - Data Explorer
4 - Data Explorer

great ! Could we choose whether the currency code could be placed before or after the number? $1000 for us but 1000€ for fr, would be perfect.