To change the date and/or 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:
•To display the date, select the format from the Date list. In the Time list, select None.
•To display the time, in the Date list, select None. In the Time list, select the format you want to apply.
•To display date and time, select the formats you want to use both in the Date and Time lists.