EasySpreadsheet can quickly covert numbers in your sheet to percentages. For example, if 0.75 was formatted as a percentage, it would be displayed as 75%.
To display numbers as percentages:
Select the cell(s) that you want to format.
Go to the Format menu, and click Cells.
A Format Cells window will appear.
Click the Number tab.
In the Category box, click Percent.
A list of percentage format types will appear in the Type box. Click on a type to select it. When you click on a type, a Sample will be displayed below.
After selecting a type, click OK.
The percentage formatting will be applied to the selected cell(s). Note that the numbers will still be numerical values after the formatting is applied.
Note: To quickly access the number formatting window, go to the Format menu, and click Number formatting.
Percentage Formatting in Advanced Mode
To apply percentage formatting in Advanced Mode:
Select the cell(s) that you want to format.
Click the Percent Style (%) button.
The selected cell(s) will be converted to percentages.
Percentages in Formulas
Users experienced in entering formulas may prefer to use percentages while typing in a cell.
Click on the cell you want the insert the percentage value into.
Type the number in the cell. Use a percent sign (%) to indicate that you have entered a percentage value. For example, type 50%.
Press Enter.
In the cell, the number will appear as a percentage. The standard, decimal number will appear in the formula bar above the spreadsheet. For example, if you enter 50%, then 50% will appear in the cell, and 0.5 will appear in the formula bar.
Examples:
Percentage |
Standard Number |
0.05% |
0.0005 |
30% |
0.3 |
100% |
1 |
350% |
3.5 |