Question

The appearance of date and time on a worksheet depends on the Applied to the cell

Answer 1

Answer:

Although Excel always stores the serial number for dates and times, how a date displays in the worksheet depends on the format of its cell. ... Right click in the cell and select "Format Cells". On the Number tab, select Date or Time, and then choose one of the Types displayed in the right column.

Answer 2

Answer:

the appearance of Date and Time on a worksheet depends on the number format applied to the cell.