1. Home
  2. Computing & Technology
  3. Spreadsheets

Basic Formatting in Excel 2003 - Part 1

By , About.com Guide

3 of 8

How to Use Percent Formatting in Excel

Setting percent formatting in Excel

Setting percent formatting in Excel

© Ted French

Formatting for Percent

  1. Select cell C4.
  2. Choose Format > Cells from the menu to open the Format Cells dialog box.

With the Format Cells dialog box open:

Note: For help on these steps, refer to the image above.

  1. Click on the Number Tab (circled in red in the image above).
  2. Select Percentage in the Category Window.
  3. Change the number of decimal places to Zero ( 0 ).

  • When finished, Click OK at the bottom of the Format Cells dialog box.
Explore Spreadsheets
About.com Special Features

Stay connected and entertained with reviews on tips on the latest HDTVs, cellphones and more. More >

Easy ways to connect two computers for networking purposes. More >

  1. Home
  2. Computing & Technology
  3. Spreadsheets
  4. Free Excel Tutorials
  5. Number Formatting in Excel Spreadsheets - Percent Formatting in Excel

©2009 About.com, a part of The New York Times Company.

All rights reserved.