Contents of the Format Currency Dialog Box

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

Contents

Field Description
Currency Sample with Your Settings Applied As you make selections on this dialog box, samples of the positive number and negative number for the currency display at the top of the dialog box with your selections applied. This allows you to easily see how the formatted currency will look, based on your selections. The number 123,456,789.00 is used for the positive and negative numbers. If you chose 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, DPS uses the default number of decimal places for that field.

You specify the currency’s default number of decimal places 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 selected Yes in the Use Default Number of Decimal Places field, this field prefills with the default number of decimal places from Currency Settings, which you cannot change.

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

Digit Grouping From this drop-down list you can select how the numbers are grouped. The digit grouping 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 remain blank.