Decimal
This article explains how to create and use a Decimal field.
The Decimal field is a numerical field used to store decimal values. It is commonly used for data such as salary, price, or other values requiring fractional precision.
NocoDB supports up to 8 digits of precision.
Create a Decimal field
- Click the
+
icon next to the last field in your table. - Enter a name for the field.
- Select Decimal from the list of field types.
- Configure the Precision setting (up to 8 digits).
- Toggle Show thousands separator to format large numbers with a thousand separator (e.g., 1,000.00 instead of 1000.00).
- (Optional) Set a default value for the field and add a description.
- Click Save field to add the field to your table.
Refer to the general guidelines on creating a field.
The default precision is set to 1 digit.
Cell display
The Decimal field appears as a numeric cell in the table, right-aligned for readability. Values are displayed with the configured number of decimal places. If the Show thousands separator option is enabled, large numbers will be formatted with a comma as the thousand separator.