which type of data are treated as date in excel
Answers
Answered by
4
Answer:
In Excel, dates are stored as numbers -- number 1 is the date January 1, 1990. You can format positive numbers in one of the date formats, to see the date that they represent. Although the entries in column C look like dates, Excel sees them as text, not real dates, and Excel will not apply number formatting to text.
Plz mark me as a brainliest
Answered by
1
hi friend
please follow me
Explanation:
In Excel, dates are stored as numbers -- number 1 is the date January 1, 1990. You can format positive numbers in one of the date formats, to see the date that they represent. Although the entries in column C look like dates, Excel sees them as text, not real dates, and Excel will not apply number formatting to text.
Similar questions