Selecting the number format

You can specify number formatting for the data in the grid. The number format string has three formats for positive, negative and zero values. The formats are separated by a semicolon.

positive format;negative format;zero string

The Number Format option on the Members tab overrides the Number Format option on the Grid tab.

To select a number format:

  1. Click the appropriate tab.
  2. In the Number Format group, select the format you want from the list. The number of characters between the decimal point and the separator indicate where the separator will display. The positive format and negative parts each represent a number format string as is defined below. The zero string is the string to use when a value is 0 and does not follow the format below. If the zero string is specified the negative format must also be specified. If the negative format is not defined it is set to -positive format. If the zero string is not defined it is set to 0.
    Number format Display string
    General 1059854.7
    #.# 1059854.7
    #.#;(#.#) 1059854.7
    #.00;-#.00 1059854.65
    #,##0;-#,##0;0 1,059,855
    $#,##0.00;-$#,##0.00 $1,059,854.65
    #,##0.0%;-#,##0.0% 105,985,465.0%
  3. Click Save Changes.

If the pre-defined formats do not meet your needs, you can specify a custom format by clicking the dialog box launcher in the Number Format group. Custom number formats can be defined for a grid style, a member style or an attribute style.