Basic Formatting in Excel 2003 - Part 1

How to Use 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.

• Excel Formatting Tutorial - Overview
• How to Use Comma Formatting in Excel
• How to Use Percent Formatting in Excel
• How to Use Currency Formatting in Excel
• How to Use Date Formatting in Excel
• How to Use Bold Formatting in Excel
• How to Change Background Colors in Excel
• Tutorial Sample Data