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.
- We will be adding the date to cell B12 with the date function in Part 2 of this tutorial.