Formatting options format headers and data based on dimension member selections.
While the formatting options are fixed, the scope of the formatting varies depending on the source of the formatting. See Formatting Documents.
Formatting Options | Description |
|---|---|
Leading and Trailing Formatting | |
Currency Symbol | Inserts currency formatting symbols into the Positive Prefix and Negative Prefix text boxes: Dollar ($), Cents (¢), Pound (£), Euro (€), Deutschmark (DM), Franc (F), and Yen (¥). |
Positive Prefix | Enters character to precede positive numeric values. |
Positive Suffix | Enters character to follow positive numeric values. |
Negative Prefix | Enters character to precede negative numeric values. Warning: The minus sign (-) is the default prefix. Deleting the default prefix without replacing it causes negative values to display positively. |
Negative Suffix | Enters character to follow negative numeric values. |
Numeric Formatting | |
Grouped Thousands | Displays numeric digits as grouped by thousands. |
Minimum Decimals | Indicates the minimum number of decimal places to display. |
Maximum Decimals | Indicates the maximum number of decimal places to display. |
Scale | Enables abbreviated values by tens, hundreds, thousands, ten-thousands, hundred-thousands, millions, and billions. |
Use Negative Color | Indicates that negative numbers are signified by a selected color. |
Select Negative Color | Enables you to select the color representing negative values. |
Samples | |
Update Samples | Updates the samples panel based on the most recent formatting selections. |
Replace Missing With | Replaces missing values with a text string or zero.
|