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.
Powered By Zergnet


You May Also Like

View Blog Post

Choosing the Right Smartphone (Infographic)

What's for Dinner, Pinner?
Get recipes based on your pins!