The solution is clunky, but it works…

Col: <=999999999.99

Subtotal: 999999999,99

Result with subtotal: 999 999 999,99

Result: 999 999 999,99

Subtotal:

IF(SEARCH(",",SUBSTITUTE(CONCATENATE({Col}),".",","))="",SUBSTITUTE(CONCATENATE({Col}),".",",")&",00",IF(LEN(SUBSTITUTE(CONCATENATE({Col}),".",","))-(SEARCH(",",SUBSTITUTE(CONCATENATE({Col}),".",",")))=1,SUBSTITUTE(CONCATENATE({Col}),".",",")&"0",SUBSTITUTE(CONCATENATE({Col}),".",",")))

Result with subtotal:

IF(LEN(Subtotal)<7,{Subtotal},IF(LEN(Subtotal)<10,MID({Subtotal},1,LEN(Subtotal)-6)&" "&RIGHT({Subtotal},6),IF(LEN(Subtotal)<13,MID({Subtotal},1,LEN(Subtotal)-9)&" "&MID({Subtotal},LEN(Subtotal)-8,3)&" "&RIGHT({Subtotal},6),">= billion!")))

Result:

IF(LEN(IF(SEARCH(",",SUBSTITUTE(CONCATENATE({Col}),".",","))="",SUBSTITUTE(CONCATENATE({Col}),".",",")&",00",IF(LEN(SUBSTITUTE(CONCATENATE({Col}),".",","))-(SEARCH(",",SUBSTITUTE(CONCATENATE({Col}),".",",")))=1,SUBSTITUTE(CONCATENATE({Col}),".",",")&"0",SUBSTITUTE(CONCATENATE({Col}),".",","))))<7,IF(SEARCH(",",SUBSTITUTE(CONCATENATE({Col}),".",","))="",SUBSTITUTE(CONCATENATE({Col}),".",",")&",00",IF(LEN(SUBSTITUTE(CONCATENATE({Col}),".",","))-(SEARCH(",",SUBSTITUTE(CONCATENATE({Col}),".",",")))=1,SUBSTITUTE(CONCATENATE({Col}),".",",")&"0",SUBSTITUTE(CONCATENATE({Col}),".",","))),IF(LEN(IF(SEARCH(",",SUBSTITUTE(CONCATENATE({Col}),".",","))="",SUBSTITUTE(CONCATENATE({Col}),".",",")&",00",IF(LEN(SUBSTITUTE(CONCATENATE({Col}),".",","))-(SEARCH(",",SUBSTITUTE(CONCATENATE({Col}),".",",")))=1,SUBSTITUTE(CONCATENATE({Col}),".",",")&"0",SUBSTITUTE(CONCATENATE({Col}),".",","))))<10,MID(IF(SEARCH(",",SUBSTITUTE(CONCATENATE({Col}),".",","))="",SUBSTITUTE(CONCATENATE({Col}),".",",")&",00",IF(LEN(SUBSTITUTE(CONCATENATE({Col}),".",","))-(SEARCH(",",SUBSTITUTE(CONCATENATE({Col}),".",",")))=1,SUBSTITUTE(CONCATENATE({Col}),".",",")&"0",SUBSTITUTE(CONCATENATE({Col}),".",","))),1,LEN(IF(SEARCH(",",SUBSTITUTE(CONCATENATE({Col}),".",","))="",SUBSTITUTE(CONCATENATE({Col}),".",",")&",00",IF(LEN(SUBSTITUTE(CONCATENATE({Col}),".",","))-(SEARCH(",",SUBSTITUTE(CONCATENATE({Col}),".",",")))=1,SUBSTITUTE(CONCATENATE({Col}),".",",")&"0",SUBSTITUTE(CONCATENATE({Col}),".",","))))-6)&" "&RIGHT(IF(SEARCH(",",SUBSTITUTE(CONCATENATE({Col}),".",","))="",SUBSTITUTE(CONCATENATE({Col}),".",",")&",00",IF(LEN(SUBSTITUTE(CONCATENATE({Col}),".",","))-(SEARCH(",",SUBSTITUTE(CONCATENATE({Col}),".",",")))=1,SUBSTITUTE(CONCATENATE({Col}),".",",")&"0",SUBSTITUTE(CONCATENATE({Col}),".",","))),6),IF(LEN(IF(SEARCH(",",SUBSTITUTE(CONCATENATE({Col}),".",","))="",SUBSTITUTE(CONCATENATE({Col}),".",",")&",00",IF(LEN(SUBSTITUTE(CONCATENATE({Col}),".",","))-(SEARCH(",",SUBSTITUTE(CONCATENATE({Col}),".",",")))=1,SUBSTITUTE(CONCATENATE({Col}),".",",")&"0",SUBSTITUTE(CONCATENATE({Col}),".",","))))<13,MID(IF(SEARCH(",",SUBSTITUTE(CONCATENATE({Col}),".",","))="",SUBSTITUTE(CONCATENATE({Col}),".",",")&",00",IF(LEN(SUBSTITUTE(CONCATENATE({Col}),".",","))-(SEARCH(",",SUBSTITUTE(CONCATENATE({Col}),".",",")))=1,SUBSTITUTE(CONCATENATE({Col}),".",",")&"0",SUBSTITUTE(CONCATENATE({Col}),".",","))),1,LEN(IF(SEARCH(",",SUBSTITUTE(CONCATENATE({Col}),".",","))="",SUBSTITUTE(CONCATENATE({Col}),".",",")&",00",IF(LEN(SUBSTITUTE(CONCATENATE({Col}),".",","))-(SEARCH(",",SUBSTITUTE(CONCATENATE({Col}),".",",")))=1,SUBSTITUTE(CONCATENATE({Col}),".",",")&"0",SUBSTITUTE(CONCATENATE({Col}),".",","))))-9)&" "&MID(IF(SEARCH(",",SUBSTITUTE(CONCATENATE({Col}),".",","))="",SUBSTITUTE(CONCATENATE({Col}),".",",")&",00",IF(LEN(SUBSTITUTE(CONCATENATE({Col}),".",","))-(SEARCH(",",SUBSTITUTE(CONCATENATE({Col}),".",",")))=1,SUBSTITUTE(CONCATENATE({Col}),".",",")&"0",SUBSTITUTE(CONCATENATE({Col}),".",","))),LEN(IF(SEARCH(",",SUBSTITUTE(CONCATENATE({Col}),".",","))="",SUBSTITUTE(CONCATENATE({Col}),".",",")&",00",IF(LEN(SUBSTITUTE(CONCATENATE({Col}),".",","))-(SEARCH(",",SUBSTITUTE(CONCATENATE({Col}),".",",")))=1,SUBSTITUTE(CONCATENATE({Col}),".",",")&"0",SUBSTITUTE(CONCATENATE({Col}),".",","))))-8,3)&" "&RIGHT(IF(SEARCH(",",SUBSTITUTE(CONCATENATE({Col}),".",","))="",SUBSTITUTE(CONCATENATE({Col}),".",",")&",00",IF(LEN(SUBSTITUTE(CONCATENATE({Col}),".",","))-(SEARCH(",",SUBSTITUTE(CONCATENATE({Col}),".",",")))=1,SUBSTITUTE(CONCATENATE({Col}),".",",")&"0",SUBSTITUTE(CONCATENATE({Col}),".",","))),6),">= billion!")))

+1

It really much harder to read long numbers without seperators.

I found this shortly after the post - which suited my needs - to use a formula and change formatting to ‘currency’ but just remove the ‘$’ sign (deleted where green highlight is)

I need a different number formatting: I need to separate the decimals with a “,” and separate the groups of digits with a space.

If you need a different separator, then in “Result with subtotal” you need to replace " " with the desired character.

Welcome to the Airtable Community!

My app, Ready Made Formulas can create a formula that formats a number as you describe. This particular formula requires a premium license, which can be very affordable compared to the time spent wrestling to get a formula to produce the exact format you want.

Kuovonne awesome thank you, will purchase cheap at the price

Hi All, we combined some answers on this topic to an easy to implement solution. Follow these steps to implement:

1. Copy this formula to an text editor (We use Visual Studio Code)


2. Find and replace all “{REPLACE_WITH_YOUR_FIELD}” To your field. Your field should be a number field with 2 decimals.


3. Paste the edited formula in a new Airtable field.

CONCATENATE("$ ",(SUBSTITUTE(IF(LEN(IF(SEARCH(",",SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",","))="",SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",",")&",00",IF(LEN(SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",","))-(SEARCH(",",SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",",")))=1,SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",",")&"0",SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",","))))<7,IF(SEARCH(",",SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",","))="",SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",",")&",00",IF(LEN(SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",","))-(SEARCH(",",SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",",")))=1,SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",",")&"0",SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",","))),IF(LEN(IF(SEARCH(",",SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",","))="",SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",",")&",00",IF(LEN(SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",","))-(SEARCH(",",SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",",")))=1,SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",",")&"0",SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",","))))<10,MID(IF(SEARCH(",",SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",","))="",SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",",")&",00",IF(LEN(SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",","))-(SEARCH(",",SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",",")))=1,SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",",")&"0",SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",","))),1,LEN(IF(SEARCH(",",SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",","))="",SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",",")&",00",IF(LEN(SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",","))-(SEARCH(",",SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",",")))=1,SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",",")&"0",SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",","))))-6)&"."&RIGHT(IF(SEARCH(",",SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",","))="",SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",",")&",00",IF(LEN(SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",","))-(SEARCH(",",SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",",")))=1,SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",",")&"0",SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",","))),6),IF(LEN(IF(SEARCH(",",SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",","))="",SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",",")&",00",IF(LEN(SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",","))-(SEARCH(",",SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",",")))=1,SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",",")&"0",SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",","))))<13,MID(IF(SEARCH(",",SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",","))="",SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",",")&",00",IF(LEN(SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",","))-(SEARCH(",",SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",",")))=1,SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",",")&"0",SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",","))),1,LEN(IF(SEARCH(",",SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",","))="",SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",",")&",00",IF(LEN(SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",","))-(SEARCH(",",SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",",")))=1,SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",",")&"0",SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",","))))-9)&"."&MID(IF(SEARCH(",",SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",","))="",SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",",")&",00",IF(LEN(SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",","))-(SEARCH(",",SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",",")))=1,SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",",")&"0",SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",","))),LEN(IF(SEARCH(",",SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",","))="",SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",",")&",00",IF(LEN(SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",","))-(SEARCH(",",SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",",")))=1,SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",",")&"0",SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",","))))-8,3)&"."&RIGHT(IF(SEARCH(",",SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",","))="",SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",",")&",00",IF(LEN(SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",","))-(SEARCH(",",SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",",")))=1,SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",",")&"0",SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",","))),6),"Max number for this formula 999.999.999,99")))," ",".")))

CONCATENATE("$ ",(SUBSTITUTE(IF(LEN(IF(SEARCH(",",SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",","))="",SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",",")&",00",IF(LEN(SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",","))-(SEARCH(",",SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",",")))=1,SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",",")&"0",SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",","))))<7,IF(SEARCH(",",SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",","))="",SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",",")&",00",IF(LEN(SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",","))-(SEARCH(",",SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",",")))=1,SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",",")&"0",SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",","))),IF(LEN(IF(SEARCH(",",SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",","))="",SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",",")&",00",IF(LEN(SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",","))-(SEARCH(",",SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",",")))=1,SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",",")&"0",SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",","))))<10,MID(IF(SEARCH(",",SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",","))="",SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",",")&",00",IF(LEN(SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",","))-(SEARCH(",",SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",",")))=1,SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",",")&"0",SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",","))),1,LEN(IF(SEARCH(",",SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",","))="",SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",",")&",00",IF(LEN(SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",","))-(SEARCH(",",SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",",")))=1,SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",",")&"0",SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",","))))-6)&"."&RIGHT(IF(SEARCH(",",SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",","))="",SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",",")&",00",IF(LEN(SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",","))-(SEARCH(",",SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",",")))=1,SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",",")&"0",SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",","))),6),IF(LEN(IF(SEARCH(",",SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",","))="",SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",",")&",00",IF(LEN(SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",","))-(SEARCH(",",SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",",")))=1,SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",",")&"0",SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",","))))<13,MID(IF(SEARCH(",",SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",","))="",SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",",")&",00",IF(LEN(SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",","))-(SEARCH(",",SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",",")))=1,SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",",")&"0",SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",","))),1,LEN(IF(SEARCH(",",SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",","))="",SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",",")&",00",IF(LEN(SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",","))-(SEARCH(",",SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",",")))=1,SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",",")&"0",SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",","))))-9)&"."&MID(IF(SEARCH(",",SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",","))="",SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",",")&",00",IF(LEN(SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",","))-(SEARCH(",",SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",",")))=1,SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",",")&"0",SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",","))),LEN(IF(SEARCH(",",SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",","))="",SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",",")&",00",IF(LEN(SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",","))-(SEARCH(",",SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",",")))=1,SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",",")&"0",SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",","))))-8,3)&"."&RIGHT(IF(SEARCH(",",SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",","))="",SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",",")&",00",IF(LEN(SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",","))-(SEARCH(",",SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",",")))=1,SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",",")&"0",SUBSTITUTE(CONCATENATE({REPLACE_WITH_YOUR_FIELD}),".",","))),6),"Max number for this formula 999.999.999,99")))," ",".")))

Thank you! It works and most important. It´s free!

Oh my gosh!! Thank you Alex, this is all I needed. I struggle to understand why a number field can’t include the type of formatting made available to currency. Meanwhile, you nailed it without the hassle, saving me I don’t know how many hours.

wahoo! this solved my problem – thank you so much!

Would still be nice to build some formatting into the regular number field, but this is a perfect workaround. thanks.

Adding my vote for more format options available for the Number field. Yes, there's kind-of a workaround that we may use with a Currency field - so why not have the same, similar and more formatting options within the Numeric field itself?

Thumbs up for this.  I find it weird that this feature is not available. Im transitioning from Google Sheets to Airtable, and the lack of such basic functionality, opposed to the advanced features Airtable implements seems strange to me.  It would be amazing if a function like TEXT in google sheets, could be implemented. The only way to format a number is to use some bizarre long-winded formulas, which are extremely ugly and inefficient.