Use the Number tab of the Formats dialog box to specify formats in a crosstab or table for selected numeric data cells that do not represent date or time information.
Note: The Number Format dialog box in the CalcBuilder contains the same components as this tab. The following descriptions of these components apply equally to the Number Format dialog box and to the Number tab.
Categories -- Specifies the desired type of numeric formatting. The available categories are as follows:
None -- Specifies that numeric formatting is based on locale settings.
Default -- Specifies that numeric formatting is based on system administrator settings.
Number -- Accepts input for decimal, separator, and scaling information; also displays the available formats for negative numbers.
Currency -- Accepts input for decimal, currency symbol, and scaling information; also displays the available formats for negative numbers.
Percent -- Accepts input for decimal information.
Custom -- Displays custom number formats, if any exist, in the Type box.
Number format options -- The following list describes the number format options:
Decimal places box -- Specifies the number of decimal places that apply to the number. Available only for the Number, Currency, and Percent categories.
Use 1000 Separator (,) box -- Specifies whether a comma should be used as a thousands separator. Available only for the Number category.
Use currency symbol box -- Specifies whether to display a currency symbol in currency data. Available only for the Currency category.
Use currency symbol box -- Specifies the currency symbol to use when you display a currency symbol.
Show "X" for name box -- Specifies whether to use a symbol to specify the scaling factor, such as K for thousands.
Scale to box -- Specifies whether to abbreviate numbers, such as 1M for 1,000,000. Available only for the Currency and Number categories.
Scale to list -- Specifies how much to abbreviate numbers numbers are abbreviated. Enabled for the Currency and Number categories.
Negative Numbers box -- Specifies the format for negative numbers. Available only for the Currency and Number categories.
Custom options -- The following list describes the custom options:
Type box -- Lists any custom formats that have been defined.
Delete button -- Deletes the custom format that is selected in the Type box. You can delete custom formats only.
Edit Type box -- Specifies a custom format, in Oracle Number Format. The best way to construct the format is to insert items from the Insert box. This ensures proper syntax. See the Oracle9i SQL Reference for information on the Oracle Number Format.
Insert box -- Presents correct syntax for parts of custom number formats. Correct Oracle Number Format syntax appears in the Edit Type box as you select tokens.
Add button -- Adds the custom format in the Edit Type box to the list in the Type box.