Microsoft® Excel® 2010 Formulas & Functions Inside Out

Formatting Numeric Values

To format the numeric values in the Purchase and Sales columns as currency values, perform the following steps:

1. Select the cells B3 to C14.

2. Click the Accounting Number Format button in the Number group on the Home Tab (see Figure 1-16).

   

   Figure 1-16. Formatting numbers as dollar values.

   The selected values are automatically displayed as decimal numbers with two decimal places, in the currency format (see Figure 1-17).

   

   Figure 1-17. The numbers are displayed as dollar amounts.