‹Blog

Airtable: Thousands Separator in a Formula Concatenated with Text

FE
Filla Editorial•beginner•Oct 29, 2025

Show commas when combining number + text

You might have a currency or number field you want to display with thousands separators even after concatenating with other text (for example a currency code). Airtable's number formatting disappears once a value becomes a text string in a formula, so you need to format it yourself.

Below are two drop‑in formulas you can adapt. They use REGEX_REPLACE to inject commas and handle edge cases.

Integer amounts

Use this when you don’t need decimals:

REGEX_REPLACE(
  REGEX_REPLACE(
    REGEX_REPLACE(
      REGEX_REPLACE(
        REGEX_REPLACE(
          REGEX_REPLACE(
            ROUND({Amount}) & "",
            "(\\d{3})$",
            ",$1"
          ),
          "(\\d*)(\\d{3}),",
          "$1,$2,"
        ),
        "(\\d{1,3})(\\d{3}),",
        ",$1,$2,"
      ),
      "(\\d{1,3}),(\\d{3}),",
      "$1,$2,"
    ),
    "^(\\d{1,3})(\\d{3}),",
    "$1,$2,"
  ),
  "^,",
  ""
) & " " & {asking-currency}

Example result: 12,345 USD

Amounts with two decimals

Keep two decimal places while still adding commas:

IF(
  {Amount},
  REGEX_REPLACE(
    REGEX_REPLACE(
      REGEX_REPLACE(
        REGEX_REPLACE(
          REGEX_REPLACE(
            REGEX_REPLACE(
              ROUNDDOWN({Amount}, 0) & "",
              "(\\d{3})$",
              ",$1"
            ),
            "(\\d*)(\\d{3}),",
            "$1,$2,"
          ),
          "(\\d{1,3})(\\d{3}),",
          ",$1,$2,"
        ),
        "(\\d{1,3}),(\\d{3}),",
        "$1,$2,"
      ),
      "^(\\d{1,3})(\\d{3}),",
      "$1,$2,"
    ),
    "^,",
    ""
  )
  & "."
  & LEFT((ROUND({Amount}, 2) - ROUNDDOWN({Amount}, 0)) * 100 & "0", 2)
  & " " & {asking-currency}
)

Example result: 12,345.67 USD

Common variations

  • Add a currency symbol: Replace the trailing currency code with a leading symbol:
    • "$" & <formatted-number> or "€" & <formatted-number>
  • Conditional message for zero: Wrap in an IF() to output explanatory text when zero:
IF(
  {Amount} = 0,
  "See request details",
  "$" & <formatted-number-with-commas-and-two-decimals>
)

Replace <formatted-number-with-commas-and-two-decimals> with the full expression from the previous section without the currency code.

Why this works

Once you concatenate a number with text, Airtable turns it into a string and no longer applies numeric display formatting. The nested REGEX_REPLACE calls insert commas every three digits from the right, then a small piece appends the two‑digit decimal part.

FAQ

Why do numbers lose their formatting in Airtable formula fields?

When you concatenate a number with text using &, Airtable converts the number to a plain string. The display formatting (thousands separators, decimal places) is a UI feature that only applies to pure number fields, not to text output from formulas.

Can I use VALUE_FORMAT or a simpler function instead of nested REGEX_REPLACE?

Airtable does not have a built-in number formatting function like VALUE_FORMAT. The nested REGEX_REPLACE approach is currently the only way to add thousands separators inside a formula field. It is verbose but reliable.

How do I show a dollar sign instead of a currency code?

Replace the trailing & " " & {asking-currency} with a leading "$" & . Place the currency symbol before the formatted number string and remove the currency code concatenation at the end.

Build forms that write directly to Airtable

Need to collect currency or formatted numbers? Filla creates forms that sync instantly with your Airtable base. Number fields, currency formatting, and all.

Try Filla free →

Source and further reading

Community discussion with the original approach and decimal variant: Number Separator in formula field with a text