Number Properties

Use the Number tab in the Properties dialog box to change the way numbers, currency values, and dates displayed throughout the application. Where formats specify fewer decimal places, values of .5 or greater round to the next integer. The original data value is retained and restored if you return to the original format.

Table 113. Number Properties

Property	Description
Select a Formatting Locale	Select a country from the drop-down list. Interactive Reporting formats number values based on the number format standards of the selected country.
Category F	Select the category for which to display number formats. Formats for that category appear in the Format field. To display all the number format in the Format pane, select All. To create a custom format, select Custom and enter the desired format in the Format field. Enter symbols, decimals, commas, and so on to indicate how to display the format. For example, enter ’MM/DD/YY’ to display the date as ‘01/01/08’, or enter $$#.###.00 to show two dollar signs before the number and a decimal to mark the thousands' place. When you create a custom format, it will always appear as a category on the machine on which it was created.
Preview	Displays the value as it will appear when you apply the format.
Format	Displays the format for the selected category. If you are creating a custom category, you can enter the desired format directly in the edit field.

Table 114. Number Properties

Option	Description	Examples
0	Integer placeholder or zero value. If a number has an integer value in this position relative to the decimal point, the integer is displayed. Otherwise, a zero is displayed.	Apply 0 to show 123 Apply 0.00 to show 123.45
*	Integer placeholder. If a number has an integer value in this position relative to the decimal point, the integer is displayed. Otherwise, nothing is displayed.	Apply #, ##0 to show 1,234
( )	Formats with parenthesis options display negative values in parentheses. Otherwise, negative values display with a minus sign.	Apply (#,##0) to show (1, 234)
;	Semicolon operates as a separator between two number formats. Typically, the semicolon separates a positive integer and a negative integer.	Apply #, ##0;(#,##0) to show 1, 234 or apply (1, 234) for a negative number
$ %	Adds the respective character to numeric values in the same position relative to the decimal point.	Apply $#,##0.00 to show $1,234.56. Apply 0% to show 3%
m d yy	Displays month, day and year in respective positions for date-coded information.	Apply mm dd yy to show 05 07 99
- /	Adds the respective character to date-coded values in the same position relative to variables.	Apply mm/dd/yy to show 06/23/99
HH MM SS	Displays hour, minute and second in respective positions for date-coded information.	Apply HH:MM:SS to show 05 01
: AM PM	Adds the respective character to time-coded values in the same position relative to variables.	Apply HH:MM:SS AM to show 17:45:10 AM