If the data in an Excel column contains mostly numbers,but also includes some dates,every cell in the column will display in the date format.

Question

Quizplus · Accepted Answer

Excel will automatically recognize and format a column as a date format if the majority of the cells in the column contain dates. However, if there are some cells in the same column that contain numbers, Excel will not change the entire column formatting to a date format. The cells with numbers will still display as numbers, and the cells with dates will display as dates.

If the Data in an Excel Column Contains Mostly Numbers,but