Change the date and/or time display format

To change the date and time display format, follow the steps below:

1.Select the desired cell or range of cells.

2.Open the Number format window, select the Date and time format.

3.Select the desired data display format:

•If the Date format is selected for the cell, select the date display format from the Date list and None from the Time list.

•If the Time format is selected for the cell, select None in the Date list, and select the time display format in the Time list.

•If you selected the Date and time format for the cell, select the date display format from the Date list and the time display format from the Time list.