Basic Formatting in Excel 2003

Formatting for date

Select cells B12.
Choose Format > Cells from the menu to open the Format Cells dialog box.


With the Format Cells dialog box open:

Click on the Number Tab (circled in red in the image above).
Select Date in the Category Window.
Select *3/14/2001 in the Type Window.

When finished, Click OK  at the bottom of the Format Cells dialog box.