Display numbers as dates or times

previous page next page

Select the cells you want to format.
On the Format menu, click Cells, and then click the Number tab.
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.

previous page start next page