To format a number

Prerequisite

This procedure assumes you have already accessed the Format Cells dialog box. For more information, see the Right-click formatting options, Formatting a metric on a report, or Formatting all the metrics on a report instructions.

Select the Number tab.
Choose a Category. The Settings and Sample sections of the dialog box change depending upon the category selected.
Use the Settings area to make your number formatting selections.
- For example, if you select Date as your category, the Settings area allows you to choose which date format to use, such as 4/12/23, April 12, 2023, 4/7/2023, and so on. If you select Fixed as the category, you can determine the number of decimal places to be displayed, whether you want numbers to be separated every three decimal places, and whether negative numbers are allowed.
- After you select a setting, the Sample area updates to provide you with an example of your selection.
You can define your own custom number format if none of the built-in formats meet your needs:
- Click Custom in the Category list.
- Enter the number formatting symbols, such as 123,456.789$.
Once you create a custom format, you can use it in other metrics as well. Click Custom in the Category list and select the format from the Custom drop-down list.
Continue formatting or click OK to apply the number formatting.