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.
Like what you've read? ...Republish it and share great business tips!
Attention: Readers, Publishers, Editors, Bloggers, Media, Webmasters and more...
We believe great content should be read and passed around. After all, knowledge IS power. And good business can become great with the right information at their fingertips. If you'd like to share any of the insightful articles on BusinessManagementDaily.com, you may republish or syndicate it without charge.
The only thing we ask is that you keep the article exactly as it was written and formatted. You also need to include an attribution statement and link to the article.
" This information is proudly provided by Business Management Daily.com: http://www.businessmanagementdaily.com/32015/date-troubles-in-excel-inconsistent-date-formats-in-column-are-frustrating "