Date, Time, and Date and Time
If you enter a number in the date, time or date and time format in a cell, the cell is automatically assigned the Date, Time or Date and Time format respectively.
If you enter a number in the date, time or date and time format in a cell, the cell is automatically assigned the Date, Time or Date and Time format respectively.