You can specify the cell format for cells or entire areas of the spreadsheet. The cell format can be a number, currency, or text.
Procedure
For example, if you select Currency, you can limit it to a specific currency. To do so, click the arrow next to the Currency field.
To set Percentage as the cell format, click Percent.
You have defined a format for an area of the spreadsheet. If you enter a value, the unit may be added as well, for example, EUR.