How to Format a Cell for Percentages in Excel

Shares & Saves

When entering data into a specific cell in Microsoft Excel, the information is presented in a way that depends on what type of formatting you choose to assign to a cell. Formatting a cell improves the appearance of a spreadsheet, but does not change the number that was entered itself.

  • Choose the specific cell, column or row which should be converted to a percentage.

  • Select "Format" from the standard tool bar and click "Cells" to open the Format Cells dialog box.

  • Click the "Number" tab on the Format Cell dialog box.

  • Select the "Percentage" option from the category list on the left side of the dialog box.

  • Choose the number of decimal places to be included in the percentage and click "OK."

Tips & Warnings

  • You can either format before or after entering your data.


You May Also Like

Read Article

Your Black Friday/Cyber Monday Survival Guide