Percentages

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:

  1. Select the cell(s) that you want to format.

  2. Go to the Format menu, and click Cells.

  3. A Format Cells window will appear.

  4. Click the Number tab.

  5. In the Category box, click Percent.

  6. 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.  

  7. After selecting a type, click OK.

  8. 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:

  1. Select the cell(s) that you want to format.

  2. Click the Percent Style (%) button.

  3. 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.

  1. Click on the cell you want the insert the percentage value into.

  2. Type the number in the cell. Use a percent sign (%) to indicate that you have entered a percentage value. For example, type 50%.

  3. Press Enter.

  4. 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