Formatting Numbers

The numbers that you enter into the cells of an Excel worksheet can represent dollar amounts, dates or percentages. To assign numeric formatting to cells, first select the range of cells you wish to apply the formatting.

Select Cells

 

Select the Format menu and select Cells.

Format Cells Dialog Box

 

The Format Cells dialog box will open. Click on the Number tab if it has not already been selected. The different catagories of the numeric formats are displayed.

Format Dialog Box

 

In this case we will be assigning the currency format to the cells. Select currency from the category list. The sample box displays the default format.

Currency Selection

 

When you click on OK the format will be applied to the cells.

Format Applied

 

back to top