1. Home
  2. Computing & Technology
  3. Spreadsheets

Basic Excel 2003 Spreadsheet Tutorial

By , About.com Guide

7 of 9

Excel 2003 Formatting - Number Formatting

Basic Excel 2003 Spreadsheet Tutorial

Basic Excel 2003 Spreadsheet Tutorial

© Ted French

Excel 2003 Formatting - number formatting

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

Number formatting refers to the addition of currency symbols, decimal markers, percent signs, and other symbols that help to identify the type of data present in a cell and to make it easier to read.

In this step we add percent signs and currency symbols to our data.

Adding the percent symbol

  1. Select cell C6.

  2. Click on the Format menu to open the drop down list.

  3. Click on Cells.. option to open the Format Cells dialog box.

  4. Click on Percentage under the Category list.

  5. Click OK.

  6. The data in cell C6 should now read as 6 %.

Adding the currency symbol

  1. Drag select cells B9 - D12.

  2. Repeat steps 2 and 3 above.

  3. Click on Currency under the Category list.

  4. Click OK.

  5. The data in cells B9 - D12 should now show the dollar symbol ( $ ) and two decimal places.

Return to Index page

Explore Spreadsheets
About.com Special Features

Holiday Central

What to eat, where to go, fun things to do and how to save money on the perfect gifts. More >

Family Tech Center

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

  1. Home
  2. Computing & Technology
  3. Spreadsheets
  4. Spreadsheet Lesson Plans
  5. Excel 2003 Formatting - Formatting Excel 2003 Spreadsheets

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

All rights reserved.