Strategy ONE

Number Section of the Properties and Formatting Dialog

Use the Number section of the Properties and Formatting dialog to specify number formatting for text fields.

Access

  1. Open a document in Design or Editable Mode.
  2. Right-click a control and choose Properties and Formatting.
  3. In the left pane, click Color and Lines.

Fields

Number

When you select one of the number format options, an example of the number category and additional options are displayed on the right.

  • Default
  • General
  • Fixed Select the number of decimal places to use, whether you want numbers to be separated every three decimal places, and whether negative numbers are allowed.
  • Currency
  • Date Choose a date type.
  • Time
  • Percentage
  • Fraction
  • Scientific
  • Custom Define your own custom number format, if none of the existing formats meet your needs.

    For internationalization, you can use the Custom option to create a dynamic currency format that changes according to the locale's default currency symbol. For a graph report, the dynamic currency is applied to the data label.

    Define the custom format in the Type field as ¤#,###.00

    where the ¤ character is created by pressing the ALT key while typing 0164. The ¤ character is replaced with the locale's default currency. For example, if the Number and Date Format is set to German (Germany), then a numeric value in this format is displayed as €1.234,56. If the Number and Date Format is set to German (Switzerland), the numeric value is displayed as Fr.1'234.56.

    The syntax shown above displays the currency symbol before the number, but you can change its location. To display the currency symbol after the number, use #,###.00¤; to display it before the number with a space, use ¤ #,###.00.

    Once you create a custom format, you can use it in other metrics as well by clicking Custom in the Category list and selecting the format from the Custom drop-down list.

  • From Grid Inherit number formatting options from the grid.