Format Data dialog: Number tab

Use this tab to configure the way that Discoverer displays number items. For example, to change default the currency symbol, number of decimal places, percent sign, and how negative numbers are displayed.

For more information, see:

"About editing worksheets"

Categories

Use this list to select a predefined format for the currently selected numeric item.

Decimal Places

Use this list to specify the number of decimal places that you want to display for the item.

Use <currency symbol>

Use this check box to display this currency symbol in front of values for the current item.

Use 1000 Separator

Use this check box to separate large numbers with a separator (e.g. English speaking countries use a comma (,) at every 1000. For example, 1,900,120.

Negative Numbers

Use this list to select how to display negative numbers on the worksheet. For example, in red, or in brackets, or prefixed with a minus symbol (-).

Type

Use this list (which is displayed when the Custom category is selected) to either choose from an existing custom type, or to create your own custom type. For example, you might want to create a new type to display money as 99999990 rather than 999G990.

Hint: To create a new custom type:

1. select a type from the Type list

2. enter changes in the Edit Type field

3. click Add to save changes

Use the Example field to see how changes affect how the item is displayed.

Notes:

• The Country setting on the Discoverer Start Page determines the currency symbol displayed. To change the currency symbol, close Discoverer, then click the Choose a Language option at the Discoverer Start Page. Then follow the screen instructions for starting Discoverer, and choose a different Country setting.

• Country settings on a browser also affect currency separators.