Changing the Formatting of Numbers

On the Preferences page, you can change the formatting of numbers in the Display Options tab. Your selections apply to all currencies, in all data forms that you have access to in the current application. These choices override the settings for individual currencies set by your administrator.

If you select Currency Setting, the currency values in the data form are displayed using the formatting initially set for individual currencies. If you select another option, your selection applies to all currencies, in all data forms to which you have access in the current application.

You can control the display of:

  To change the formatting of displayed numbers:

  1. Select File, then Preferences.

  2. Click the Planning icon and select Display Options.

  3. Under Number Formatting, select options, as summarized in this table:

    Option

    Example

    Thousands Separator

    None: 1000

    Comma: 1,000

    Dot: 1.000

    Space: 1 000

    You can enter values with or without a thousands separator.

    Decimal Separator

    Dot: 1000.00

    Comma: 1000,00

    You can enter values with or without a decimal separator.

    Negative Sign

    Prefixed Minus: -1000

    Suffixed Minus: 1000-

    Parentheses: (1000)

    Negative Color

    Black: Negative numbers are black

    Red: Negative numbers are red

    Note:

    Select the Currency Setting option to apply the formatting that the administrator set as the Currency dimension property.

  4. Click Save.

    Note:

    Formatting selections take effect when you click outside the cell. If you select a setting other than Use Application Default for the thousands separator or the decimal separator, you must change both separators with the Use Application Default option. You cannot select the same option for the thousands and decimal separators. See also Entering Percentage Values.