> ## Documentation Index
> Fetch the complete documentation index at: https://help.teable.ai/llms.txt
> Use this file to discover all available pages before exploring further.

# Formatting

> Control how field values appear, such as decimal places, percentages, currency symbols, date formats, and time formats.

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 Formatting

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           |

## Date and Time Formatting

Date and time fields can set the date format, time format, and timezone.

| 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`         |

Time formats support 24-hour time, 12-hour time, or no time display. Timezones can use a fixed timezone or follow the viewer's location.

## 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.