eHow launches Android app: Get the best of eHow on the go.

Search
Now in the UK!
  1. Home »
  2. Computers »
  3. Computer Software »
  4. Spreadsheets »
  5. How to Format a Cell for Percentages in Excel
More Articles Like This
More by This Author
How To

How to Format a Cell for Percentages in Excel

Contributor
By eHow Contributing Writer
(0 Ratings)

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.

Difficulty: Moderately Easy
Instructions
  1. Step 1

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

  2. Step 2

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

  3. Step 3

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

  4. Step 4

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

  5. Step 5

    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.
Who Can Help
Subscribe

Post a Comment

Post a Comment

Related Ads

  • See How Others Did It
  • Have you done this? Click here to let us know.
I Did This
Tags
Get Free Computers Newsletters

Copyright © 1999-2009 eHow, Inc. Use of this web site constitutes acceptance of the eHow Terms of Use † and Privacy Policy †.   en-US Portions of this page are modifications based on work created and shared by Google and used according to terms described in the Creative Commons 3.0 Attribution License. † requires javascript

Partner Sites
eHow Computers
eHow_eHow Technology and Electronics