How to set the currency symbol for numeric items

You can specify the currency symbol to use for numeric values on a worksheet. For example, you might want to display the dollar symbol next to sales figures.

To set the currency symbol for a numeric item:

1. Display the worksheet that you want to edit.

2. Select one or more numeric worksheet items to edit.

   For example, click on one or more item headings in the data area.

   Hint: You can select more than one item by pressing the Ctrl key and clicking another item. In the example below, the Profit SUM and Sales SUM items are selected.

   
   Description of the illustration ed15.gif
   
   

3. Choose Format | Data to display the "Format Data dialog: Format tab".

4. Display the "Format Data dialog: Number tab".

   
   Description of the illustration ed13.gif
   
   

5. Select Currency in the Categories list.

6. Select the currency symbol to use from the Display Symbol drop down list.

7. Click OK to save the changes you have made and close the dialog.

   Discoverer displays the selected currency symbol in front of the worksheet item values. The example below shows the dollar ($) currency symbol displayed next to Profit SUM values and Sales SUM values in a worksheet.

Description of the illustration ed11.gif