You can format how numbers are displayed in a grid. You can specify the following options for an entire grid or for individual cells, rows, or columns:
To format numbers in a grid:
Create a grid in a report in the Report Designer, or open an existing report containing a grid.
You can view the results of your number format option selections in the Sample section at the bottom of the Number tab.
Optional: Specify a prefix or suffix for positive numbers by selecting a symbol from the Prefix or Suffix drop-down list, or type a user-defined symbol into the Prefix or Suffix fields. A prefix symbol is placed to the left of each positive value. A suffix symbol is placed to the right of each positive value.
You can use a prefix or suffix to reverse the sign of an account member without inserting another row or column. When using conditional formatting, you specify an account row and set the condition. Then, in the Positive Number Symbols Prefix fields, enter the negative (-) symbol and click OK twice. The negative (-) symbol is displayed in front of the numbers for that row. |
Optional: Specify a prefix or suffix for negative numbers by selecting a symbol from the Prefix or Suffix drop-down list box or type a user-defined symbol into the Prefix or Suffix fields. A prefix symbol is placed to the left of each negative value. A suffix symbol is placed to the right of each positive value.
Optional: To display negative values in red, select the Display in Red option. By default, this option is deselected.
Select the number of decimal places to apply to a number from the Decimal Places drop-down list box. The default ranges are from 0 to 9.
Select one of the following for Grouping and Decimal Symbols:
Defined by Preferences to use the symbols specified in the user Preferences dialog box, enabling users to determine which symbols are used.
Defined in Report to specify thousands and decimal separators for the current report:
Select a character for separating thousands in values from the Thousands Separator drop-down list. For example, select comma ( , ) to display the value (1,000), or select period ( . ) to display the value (1.000). The options are: comma ( , ), period ( . ), underscore ( _ ) and Space. Alternatively, you can specify another symbol in the drop-down by highlighting the field and typing another symbol.
Select a character to represent decimal points (for example, 900.06) from the Decimal Separator drop-down list box. The options are: comma ( , ), period ( . ), underscore ( _ ) and Space. Alternatively, you can specify another symbol in the drop-down by highlighting the field and typing that symbol.
Select or enter a number from the Scale Value By drop-down list box by which to multiply values for scaling purposes. The default scaling option is 1, which does not scale values. If you select .001 instead, the value 2,000 is displayed as 2. The options are: percentages, tens, hundreds, thousands, ten thousands, hundred thousands, millions, or billions. Alternatively, you can specify an amount in the drop-down box.
Click Apply to apply the number formatting you specified for the selected cells, and then Click OK to save the number formatting and close the dialog box.