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