Leading and Trailing Formatting |
Currency Symbol | Inserts the following currency formatting symbols into the Positive Prefix and Negative Prefix text boxes: Dollar ($), Cents (¢), Pound (£), Euro(E), 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 Check Box | 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 Check Box | 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 either a text string or zero. |