1. Computing
About.com
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:

  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.

©2013 About.com. All rights reserved.