Date troubles? Inconsistent date formats in a column are frustrating. Periodically, Excel seems unwilling to let you change your mind when you accidentally get two different date formats in a column. Sometimes, it’s as easy as changing the format, other times you will need this two-step process.
First, clear the formats. On the Home tab, Editing group, you’ll see a white button that looks like an eraser. Click on it to find Clear Formats. This changes your dates to their serial numbers. Now, just format the column in the desired date format. All the formats should now agree.