Number Format
You can format date and numbers, by clicking on the airtable fields, inserted the document editor. In the format option, we list some of the commonly used formats for date and number fields. You can also specify your own format. This doc will help you figure out some of the common date time and number syntax.
If you want date or currency to be localized, make sure to specify Locale on the right side panel. Make sure to specify TimeZone for date, as the default is UTC.
Number Format
🔢 Number Formatting Overview
Number formatting lets you control how numbers appear — with thousands separators, decimal places, currency symbols, percentages, and more. You define how numbers are displayed using special pattern characters.
Commonly used formats
| Example Output | Pattern | Description |
|---|---|---|
| 123 | 0 | Integer without decimals |
| 00123 | 00000 | Pads with leading zeroes |
| 123.46 | 0.00 | Always two decimal places (rounded) |
| 123.4 | 0.0# | One or two decimal places |
| 1,234 | #,##0 | Thousands separator |
| 1,234.50 | #,##0.00 | Thousands + two decimals |
| $1,234.50 | $#,##0.00 | Currency format with symbol |
| (1,234.50) | #,##0.00;(#,##0.00) | Accounting style negative numbers |
| ($1,234.50) | $#,##0.00;($#,##0.00) | Accounting style negative currency |
| 75% | 0% | Percent, no decimals |
| 75.00% | 0.00% | Percent with decimals |
| 0 units | 0 'units' | Appends literal text |
| $001.20 | $000.00 | Currency with padded integer part |
| $1,234.00 | ¤#,##0.00 | Uses currency placeholder |
# — Optional digit
Displays a digit only if it exists in that position. Extra zeros are not shown.
Pattern: ###
Input: 42 → Output: 42
0 — Required digit
Always displays a digit, padding with zeros if necessary.
Pattern: 000
Input: 5 → Output: 005
. — Decimal separator
Separates the integer part from the fractional part.
Pattern: 0.00
Input: 1.5 → Output: 1.50
, — Grouping separator
Defines where digit grouping (e.g., thousands separator) should appear.
Pattern: #,##0
Input: 10000 → Output: 10,000
% — Percent symbol
Multiplies the number by 100 and appends a % sign.
Pattern: 0%
Input: 0.75 → Output: 75%
¤ — Currency symbol placeholder
Replaced with the appropriate currency symbol (based on locale).
Pattern: ¤#,##0.00
Input: 1234.5 → Output: $1,234.50
'...' — Literal text
Encloses characters that should appear exactly as written.
Pattern: 0 'kg'
Input: 5 → Output: 5 kg
; — Pattern separator
Defines separate formats for positive and negative numbers.
Pattern: +#;-#
Input: -42 → Output: -42