Formatting controls how field values appear. It does not change the field’s raw data. It only changes what users see in the table, such as decimal places, percentages, currency symbols, date formats, and time formats.
Number fields can use display formats that match your work:
| Format | Description |
|---|
| Decimal | Set how many decimal places to show |
| Percentage | Show a number as a percentage, such as 0.25 as 25% |
| Currency | Add a currency symbol and set decimal places |
| Setting | Example |
|---|
| US style | 12/31/2023 |
| European style | 31/12/2023 |
| Asian style | 2023/12/31 |
| ISO standard | 2023-12-31 |
| Year and month only | 2023-12 |
| Month and day only | 12-31 |
| Year only | 2023 |
| Month only | 12 |
| Day only | 31 |
Field Basic Data Types
| Teable field type | Basic data type | Supports formatting | Dynamic type flag |
|---|
| Single line text | Text | No | No |
| Long text | Text | No | No |
| User | Text | No | No |
| Attachment | Text | No | No |
| Checkbox | Boolean | No | No |
| Multiple select | Text | No | No |
| Single select | Text | No | No |
| Date | Date | Yes | No |
| Number | Number | Yes | No |
| Duration | Number | Yes | No |
| Rating | Number | No* | No |
| Formula* | Dynamic | Yes* | Yes |
| Rollup* | Dynamic | Yes* | Yes |
| Count | Number | Yes | No |
| Link | Text | No | No |
| Created time | Date | Yes | No |
| Last modified time | Date | Yes | No |
| Created by | Text | No | No |
| Last modified by | Text | No | No |
| Auto number | Number | Yes | No |
| Button | Text | No | No |
Notes
- Rating fields show an interactive rating bar. They do not use number formatting, but they are still number fields and can be used in numeric calculations.
- Formula and rollup formatting depends on the output type. If the result is a date or number, it can be formatted. If the result is text or boolean, formatting does not apply.
- Referenced fields still follow the basic value type of the original field.
Last modified on May 26, 2026
