# Apply formatting to numbers or dates

> Change how numbers, currencies, and dates are displayed in a report, or clear a custom format.

By default, reports you create in the Reports and Dashboards app display numbers, currencies, and dates in the following formats.

| Data type | Examples |
| --- | --- |
| Numbers | 1,234  <br>1,234.50  <br>1,234.56 |
| USD currencies | $0  <br>$1,234  <br>$1,234.56 |
| Non-USD currencies | CAD 0  <br>CAD 1,234  <br>CAD 1,234.00 |
| Dates | 01/02/2026 |
| Datetimes | 01/02/2026 9:51 AM PST |

You can customize this to apply your preferred display format.

## Apply number formatting

You can customize the format to change how numbers and currency amounts are displayed in reports. To do so, follow these steps:

1.  Click the three dots on the name of the field and select **Number formatting**.
2.  Select your preferred display format. You can select from the following options:
    -   **1, 234.56**. Displays the value as an integer with two decimal places.
        
    -   **123,456%**. Displays the value as a percentage.
        
    -   **1.23E+3**. Displays the value as scientific notation.
        
    -   **1.2k**. Displays a rounded value with an abbreviation.
        
    -   **Custom**. Define your own custom formatting rules. Type in your desired pattern in the **Format pattern** field. Use pound (#) or zero (0) as variables that will be populated with numbers. A preview will be shown so you can see what it will look like in the report.
        
        > **Tip:**
        > If you want to make a modification to one of the existing display formats, first select it to apply it to your report, and then select **Custom**. The **Format pattern** field will show the pattern of the currently applied format. You can then modify it as desired.
        
3.  Save the report to save your changes.

## Apply date formatting

You can customize the format to change how dates are displayed in reports. To do so, follow these steps:

1.  Click the three dots on the name of the field and select **Date formatting**.
2.  Select your preferred display format. You can select from the following options:
    -   **2026-03-04**. The date in ISO 8601 format.
    -   **March 04, 2026**. The date in month-day-year format.
    -   **Wednesday**. The date’s day of the week.
    -   **Wednesday 03:14 PM**. The day of the week and timestamp.
    -   **3:14 PM**. The timestamp.
    -   **Custom**. Define your own custom formatting rules. Type in your desired pattern in the **Format pattern** field. A preview will be shown so you can see what it will look like in the report.
3.  Save the report to save your changes.

## Clear formatting

After you’ve applied custom number or date formatting, you can remove it by following these steps:

1.  Click the three dots on the name of the field and select **Number formatting** or **Date formatting**, as applicable.
2.  Select **Clear formatting**.

The values will be reset back to their default display formats.

## See also

-   [Get started with reports](https://developer.rippling.com/documentation/rippling-platform/reports/getting-started)
-   [Charts and grouping in reports](https://developer.rippling.com/documentation/rippling-platform/reports/visualization)
-   [Configure drilldown reports](https://developer.rippling.com/documentation/rippling-platform/reports/drilldowns)
-   [Share and download reports](https://developer.rippling.com/documentation/rippling-platform/reports/sharing)

Source: https://developer.rippling.com/documentation/rippling-platform/reports/formatting

> For the complete documentation index, see [llms.txt](https://developer.rippling.com/llms.txt). Public pages have a Markdown version at the same URL with .md added.
