Display numbers as dates or times

1. Select the cells you want to format.
2. On the Format menu, click Cells, and then click the Number tab.
3. In the Category list, click Date or Time, and then click the format you want to use.

Note  If you don’t find what you’re looking for, you can create a custom number format by using format codes for dates and times.