Percentage Data Type |
The Percentage data type formats your text as a number and a "%", and represent portions of a greater whole. Once you choose to format your text as a percentage, you can customize the appearance by specifying a locale and various formatting options.
To format your text as a percentage
On the Data Type tab, the following options are available for data sources formatted as percentages:
Locale: Specifies the language and country of the selected numerical 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 zeroes: When enabled, displays one or more zero numerals before a decimal number.
Pad with zeroes to maximum number of decimal places: When enabled, adds one or more zero numerals to a number not matching the number of decimal places.
Decimal places: Specifies the number of decimal places to include in the number.
Positive percentage: Defines the formatting of any positive percentages contained in the data source.
Negative percentage: Defines the formatting of any negative percentages contained in the data source.