Formatting - Teable

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.

Last modified on May 26, 2026