1. Home
  2. Computing & Technology
  3. Spreadsheets

Basic Formatting in Excel 2003 - Part 1

By , About.com Guide

4 of 8

How to Use Currency Formatting in Excel

Setting currency formatting in Excel

Setting currency formatting in Excel

© Ted French

Formatting for Currency

  1. Select cells D7 to D10.
  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 Currency 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.

  • We will be adding formulas to cells D7 to D10 with the net salary formula in Part 2 of this tutorial.
Explore Spreadsheets
About.com Special Features

Vote in the Reader's Choice Awards

What are the best instant messengers, apps, and editors? You decide, in our 2010 technology awards program. More >

iPad Central

Is Apple's new tablet computer impractical, a must-have -- or both? We'll help you figure it out. More >

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

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

All rights reserved.