The appearance of date and time on a worksheet depends on the dash applied to the cell
Answers
Answered by
29
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.
Answered by
7
The appearance of date and time on a worksheet depends on the format applied to the cell.
Explanation:
- Excel stores date and time in the form of number which is called the date serial number. It is a regular number that has been formatted and looks like a date. Date serial number integer portion represents the day and the portion which is decimal represents the time.
- Excel provides each date to a special numeric value. The date serial number column displays the date column value in their date serial equivalent. Time represents a decimal fraction. It follows at least h: m: m that is hour and minute.
Learn more about worksheet
How can you rename a worksheet? explain.
https://brainly.in/question/4801435
Can we print worksheet and related chart on same page
https://brainly.in/question/1565814
Similar questions