Forum Discussion

CDKunte's avatar
CDKunte
Copper Contributor
Jan 30, 2024

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 dates accending/descending- as it leaves them out. 
I have attempted to select all the dates and format them together, but it didn't work. Selecting the format and retyping each date worked for a while, but that has stopped working. 
In the attached image, all unselected dates are not recognised in the same format as the rest. 
Help PLEASE...

  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    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?

Resources