Date and time in Excel can be displayed in various forms. To apply the format Dates or Time, follow the instructions below.
- Select cell A1.
- Right click and select Format Cells (cell format).
- The list Category (Number formats) specify Date (Date) and set the format type you want to display the date.
- Press OK.
Note: To apply the time format, select Time (Time) from the list of number formats.
- Dates in Excel are stored as numbers and represent the number of days that have passed since January 0 1900 years. Time is treated by the program as a number between 0 и 1. To see this, change the number format of the cells A1, B1 и C1 on General (General).
Note: As you can see, 41083 days since January 0, 1900 – the same as June 23, 2012. 6:00 presented as 0.25 – that is, a quarter of a day.
- You can enter time like this: 6:00. But Excel will display it in formula bar as 6: 00: 00 AM. AM is used as a determinant of night and morning time. PM – afternoon and evening.
- Change the number format of a cell С1 on Date (Date).
Note: Cell С1 still contains the value 41083.25. We only changed the appearance, not the value itself.
- Finally, if you can’t find a suitable date or time format, create your own.