Multicurrency: Export

Export format options determine how data appears in the output file. You can select the formatting options for currency from Administration. Under Tools, select Export. In the Exports grid, select the double arrows beside the process to expand the row and then select Set format options. On the Currency tab, you can specify how currencies should appear in the exported data.

The table below explains the items on the Currency tab.

Screen Item

Description

Currency symbol

Select the currency symbol to use. You can choose one of these options:

Use currency setting — Uses the currency setting you selected for the currency. This can be the ISO code, symbol, or both depending on the default currency type for the region.

Display ISO code — Uses the ISO code associated with the currency.

Display symbol — Uses the currency symbol associated with the currency.

Display no symbol — Uses no currency symbol.

Number of digits after decimal

Select the number of digits to use after decimals. You can choose one of these options:

Use currency setting — Uses the number of digits associated with the currency.

Use custom value — Uses the number of digits you enter in the field.

Digit grouping symbol

Select the digit grouping symbol to use. You can choose one of these options:

Use system setting Windows Region and Language settings.

Display space — Uses a blank space rather than a symbol.

Display custom symbol — Uses the custom symbol you enter in the field.

Display no symbol — Digits are not grouped.

Decimal symbol

Select the decimal symbol to use. You can choose one of these options:

Use system setting Windows Region and Language settings.

Display space — Uses a blank space rather than a symbol.

Display custom symbol — Uses the custom symbol you enter in the field.

Example

The Example display shows how currency data appears with the selected options.