1. Computing

Basic Formatting in Excel 2003 - Part 1

By

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:

  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.
  1. About.com
  2. Computing
  3. Spreadsheets
  4. Formatting Options in Excel
  5. Currency Formatting in Excel

©2014 About.com. All rights reserved.