Select format type

You can specify the format type for cells or entire areas of the spreadsheet. A format type can be a number, currency, or text.

Prerequisite

A table view is created for the query or the ad-hoc analysis.

Procedure

  1. Start the query or the ad-hoc analysis.
  2. Click Output Output if the table is hidden.
  3. Activate the Spreadsheet tab bar.
  4. Select the relevant area in the sheet for which you want to define a category.
  5. Click the Format type Format type box and select a category.

    If you select the Currency format type, you can limit it to a specific currency. To do so, click the arrow next to the Currency Currency field.

    If you want to set a percentage as a format type for cells click Percent Percent.

You have defined a category for an area of the sheet. If you enter a value, the unit may be added as well, for example, EUR.