Forum Discussion
Excel Not Formating Dates
I have a column of dates in my table, but Excel is not recognising a handful of them in the same format as the rest. This is causing big issues if I have to search for relative dates or sort the date...
Select all those cells, click Data, Text to columns and click Finish. That should "sort" the issue. Question is: How did the misbehaving dates get into your spreadsheet to start with?