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
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 field.
If you want to set a percentage as a format type for cells click 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.