Contents of the Format Currency Dialog Box

To aid you in making selections, an example that reflects your changes to the currency settings displays at the top of the dialog box. This example updates as you make changes.

Contents

Field Description
Currency Sample with Your Settings Applied Samples of the positive number and negative number for the currency display at the top of the dialog box, with your selections applied, so that you can easily see how the formatted currency will look. The number 123,456,789.00 is used for the positive and negative numbers. If you selected a format for displaying zero numbers in the Zero Number field, that format also displays at the top of the dialog box.
Symbol Display Use this field to specify whether the currency symbol, currency code, or neither displays.
Symbol Location Use this field to determine whether the currency symbol or currency code (the one that you selected in the Symbol Display field) displays to the left or right of the currency number.
Use Default Number of Decimal Places When you select this option, Vantagepoint uses the default number of decimal places for that field, as specified in Currency Settings (Settings > Currency > Options). For normal numbers, the default is the number of decimals that are displayed for that field by default on the report.
Decimal Places If you set the Use Default Number of Decimal Places option to Yes, this field prefills with the default number of decimal places from Currency Settings, which you cannot change.

If you set the Use Default Number of Decimal Places option to No, use this field to specify the number of decimal places to use for the currency. Options are: 0, 1, and 2.

Digit Grouping Select how the numbers are grouped. The options are:
  • 123,456,789: The number is grouped by three digits.
  • 123456789 : There is no digit grouping.
Negative Number Select how you want negative currency amounts to display. The options are:
  • Parentheses: The number is surrounded by parentheses.
  • Sign on Front: The negative sign displays before the number.
  • Sign on Back: The negative sign displays after the number.
Zero Number Select how you want zero currency amounts to display. The options are:
  • 0: Zero values are represented by a 0.
  • -: Zero values are represented by a dash.
  • Do not display: Zero values are blank.