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
Open a spreadsheet.
Activate the Start tab bar.
Select the area of the spreadsheet for which you want to define the cell format.
Click the Cell format field and select a format.
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.