How To Convert Wrongly Formatted Dates
Have you ever copied or imported data into Excel and realized that the date formats were all wrong. For example, your computer may recognize dates in dd/mm/yy format and you've just copied data, that includes a date column, from another source and the date format there is mm/dd/yy.
You'll notice that Excel recognizes some of the dates but for most it won't. You'll see the dates that Excel has recognized as right-aligned cells and those it didn't recognize, and assumed was text, as left-aligned cells. If you look closely you'll see that even the cells Excel did recognize as dates are wrong - the months and days are switched.
It can be quite a task to fix all of these dates. In the early days I tried various techniques to solve this problem, but all of them were time consuming. Then I discovered a simple little trick using Excel's 'Text to columns' option.
Here's what you can do...
Now, isn't that cool?