---
title: "Number-Based Fields in Airtable | Airtable Support"
slug: "number-based-fields-in-airtable"
description: "In Airtable, fields allow you to organize all the details for any record in your base, so they can easily be sorted, managed, and analyzed. In this article, learn specifically about Airtable's number-based fields and how to use then."
updated: 2026-01-14T16:37:23Z
published: 2026-01-14T16:37:23Z
stale: true
---

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

# Number-based fields in Airtable

| **Plan availability** | All plan types |
| --- | --- |
| **Permissions** | - **Owner** /**Creator** - Have access to all field configuration options. Additionally everything editors, commenters, or read-only users can do. - **Editor** - Can sort by, filter by, group by, or hide the field within a view. - **Commenter** / **Read-only** - Copy a field's URL |
| **Platform(s)** | Web/Browser, Mac app, and Windows app |

NoteConsider having [Omni](https://support.airtable.com/docs/using-omni-ai-in-airtable) create a field for you. With Omni's AI capabilities, you can use plain text requests to build, update, and query in your Airtable base. You can also create [AI-powered fields called field agents](https://support.airtable.com/docs/using-airtable-ai-in-fields).  

## Autonumber fields

Autonumber fields automatically generate unique and incremented numbers for each record. Autonumbers can be helpful when you need a unique identifier for each record or when using a formula in the primary field.

> [!CAUTION]
> Note
> 
> Autonumber fields are not designed to count the number of records in a table. When a record is deleted, the remaining records are not re-numbered—leaving gaps in the numbering. To re-number an autonumber field, either delete and re-create an autonumber field or convert it to a different field type and then revert it to an autonumber field. Check out our Airtable Community for more info and suggestions for [conditional auto-numbering](https://community.airtable.com/t5/base-design/conditional-auto-numbering-multiple-autonumber-sequences-per/td-p/46848).

1. Open your [Airtable home screen](https://airtable.com/).
2. Open the base where you want to create an autonumber field.
3. [Add](https://support.airtable.com/docs/airtable-field-actions#adding-and-deleting-fields) or [edit a field](https://support.airtable.com/docs/field-type-overview#field-configuration-menu).
4. Search for and select **Autonumber**, then click **Create field**.

## Currency fields

A currency field is a specific type of number field that formats the number as a currency amount. You can specify a currency symbol (the default symbol is $), the number of significant digits, and whether or not to allow negative currency amounts.

> [!CAUTION]
> Note
> 
> Airtable doesn't support using multiple currencies within the same currency field.

1. Open your [Airtable home screen](https://airtable.com/).
2. Open the base where you want to create a currency field.
3. [Add](https://support.airtable.com/docs/airtable-field-actions#adding-and-deleting-fields) or [edit a field](https://support.airtable.com/docs/field-type-overview#field-configuration-menu).
4. Search for and select **Currency**, then create **Create field**.
  1. You can optionally update the default settings by clicking **Formatting**.
  2. Lastly, you can set a default field value for every new record created within the table by clicking **Default** and entering your preferred number.

![](https://cdn.airtable.document360.io/d0ee2ee4-3f78-47c7-b388-85e40be9fb89/Images/Documentation/Screenshot%202023-09-19%20at%205.14.47%20PM.png)

## Percent fields

The percentage field type hosts numerical values formatted as percentages. The values in a percent field are shown as fractions of 100 with the percent symbol. For example, .75 in a percent field is represented as 75%.

For a more general-purpose numeric field type, try a [number field](/v1/docs/number-field-type)to represent integers or decimals.

> [!CAUTION]
> Note
> 
> Percent fields created before May 2019 were stored using a format are now converted to number fields. Read more about this change in the number legacy section of the [Number field type article](https://support.airtable.com/docs/number-field-type#show-percent-sign-legacy).

1. Open your [Airtable home screen](https://airtable.com/).
2. Open the base where you want to create a percent field.
3. [Add](https://support.airtable.com/docs/airtable-field-actions#adding-and-deleting-fields) or [edit a field](https://support.airtable.com/docs/field-type-overview#field-configuration-menu).
4. Search for and select **Percent**, then click **Create field**.

## Number fields

The number field type is a field type designed to hold numbers. The number field type is a general-purpose field type for most numerical values, like the number of chairs of a particular type your furniture business has in stock, or the distance from one city to another.

1. Open your [Airtable home screen](https://airtable.com/).
2. Open the base where you want to create number field.
3. [Add](https://support.airtable.com/docs/airtable-field-actions#adding-and-deleting-fields) or [edit a field](https://support.airtable.com/docs/field-type-overview#field-configuration-menu).
4. Search for and select **Number**, then click **Create field**.
  1. You can optionally update the default settings by clicking **Formatting**.

## Legacy default values in fields

> [!CAUTION]
> Note
> 
> Single line text, number, currency, and percent fields in bases created before January 31, 2024, offer the option to toggle on/off "Apply default value for all actions."

To toggle on the "Apply default value for all actions" setting:

1. Open your [Airtable home screen](https://airtable.com/).
2. Open the base with the field where you want to enable the “Apply default value for all actions" setting.
3. Click the dropdown arrow next to the field you want to edit.
4. Click **Edit field**.
5. Toggle on the “Apply default value for all actions" setting.

![](https://cdn.airtable.document360.io/d0ee2ee4-3f78-47c7-b388-85e40be9fb89/Images/Documentation/Screenshot 2023-11-25 at 5.02.30 PM (1).png)

Any fields displaying "Apply default value for all actions" rely on a legacy default value used inconsistently. You can toggle "Upgrade to consistent default value behavior" on to address the previous inconsistencies.

The following scenarios did not use the default value for legacy fields but will after enabling "Upgrade to consistent default value behavior:"

- Using the [Airtable automation action: Create record](/docs/create-record-action) without specifying a field value.
- Using public APIs to create a record without specifying a field value.
- Submitting a form without a legacy field.
- Importing a CSV without specifying field mapping for the related field.

## Rating fields

The rating field allows you to rate your records for ranking or quality assessment.

> [!CAUTION]
> Note
> 
> Users on [paid Airtable plans](https://airtable.com/pricing) can update the style of the field's rating symbol from the default yellow star.

1. Open your [Airtable home screen](https://airtable.com/).
2. Open the base where you want to add a rating field.
3. [Add](https://support.airtable.com/docs/airtable-field-actions#adding-and-deleting-fields) or [edit a field](https://support.airtable.com/docs/field-type-overview#field-configuration-menu).
4. Search for and select **Rating**, then click **Create field**.

## Formatting number-based fields

To access formatting options in number-based fields:

1. Click the **⌄**icon next to the name of the number-based field you want to format.
2. Then, click **Edit field**.
3. Next, click on the **Formatting**tab.
  1. From the formatting tab, you have a variety of options to choose from: Format, Presets, Decimal places, Thousands and decimal separators, the option to toggle whether to Show thousands separators, and Large number abbreviation.
4. After configuring the format of the field, you'll see the option to "Preview" the output at the bottom of the field configuration window.

## FAQs

**What is the max date that can be stored in a date field?**

The max date for a date field is 12/31/9999.

**Can I store numbers that are larger than 15 digits?**

Numbers with 15+ digits are not recommended for storing in Airtable records because they are automatically rounded up.

We recommend using a text field in these cases, as it is not possible to use the [ROUNDDOWN](https://community.airtable.com/other-questions-13/rounddown-function-17701) or other formula functions to return the initially entered number.