For AI agents: an index of this documentation is at https://developer.rippling.com/llms.txt. Public pages have a Markdown version at the same URL with .md added.

Skip to main content
guide

Apply formatting to numbers or dates

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

Use with AI:Rippling AI ChatGPT Claude Cursor

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

Data typeExamples
Numbers1,234
1,234.50
1,234.56
USD currencies$0
$1,234
$1,234.56
Non-USD currenciesCAD 0
CAD 1,234
CAD 1,234.00
Dates01/02/2026
Datetimes01/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​