Open topic with navigation

The Currency data type formats your text as a numerical input of a monetary amount. Once you choose to format your text as currency, you can customize the appearance by specifying a locale and various formatting options.

To format your text as currency

On the Data Type tab, the following options are available for data sources formatted as Currency:

• Locale: Specifies the language and country of the selected currency format.

• Use native numerals: Specifies whether to use Arabic numerals or the native numeric system when using a Locale that supports alternative numeric systems. Available for the following locales: Arabic (Bahrain, Egypt, Iraq, Jordan, Kuwait, Lebanon, Oman, Qatar, Saudi Arabia, Syria, U.A.E., Yemen), Assamese (India), Bengali (Bangladesh, India), Dari (Afghanistan), Gujarati (India), Kannada (India), Khmer (Cambodia), Konkani (India), Lao (Lao P.D.R.), Malayalam (India), Marathi (India), Nepali (Nepal), Oriya (India), Pashto (Afghanistan), Persian (Iran), Punjabi (India), Sanskrit (India), Telugu (India), Thai (Thailand), and Urdu (Islamic Republic of Pakistan).

• Use digit grouping separator: When enabled, separates the number into groups using a delimiter; this digit is also known as the thousands separator because it separates the number at every third digit, the thousands spot.

• Show leading zero: When enabled, displays a zero before a decimal number.

• Decimal places: Specifies the number of decimal places to include in the number.

• Positive currency: Defines the formatting of any positive currency values contained in the data source.

• Negative currency: Defines the formatting of any negative currency values contained in the data source.