Spreadsheet not sorting or filtering

%3CLINGO-SUB%20id%3D%22lingo-sub-1847119%22%20slang%3D%22en-US%22%3ESpreadsheet%20not%20sorting%20or%20filtering%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1847119%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20monthly%20spreadsheet%20that%20will%20not%20filter%20or%20sort%20by%20date.%26nbsp%3B%20The%20column%20is%20in%20date%20format%2C%20the%20numbers%20are%20not%20imported%2C%20I%20have%20cleared%20all%20filters.%26nbsp%3B%20All%20of%20the%20other%20months%20I%20have%20had%20no%20problem%2C%20but%20October%20will%20not%20sort.%26nbsp%3B%20I%20copied%20the%20page%20to%20a%20new%20document%20and%20it%20still%20won't%20sort.%26nbsp%3B%20Any%20ideas%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1847119%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1847730%22%20slang%3D%22en-US%22%3ERe%3A%20Spreadsheet%20not%20sorting%20or%20filtering%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1847730%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F855271%22%20target%3D%22_blank%22%3E%40Pamipj%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EPlease%20check%20if%20you%20actually%20have%20dates%2C%20not%20texts.%20To%20apply%20date%20format%20is%20not%20enough%20if%20you%20have%20texts%2C%20texts%20shall%20be%20converted%20to%20dates.%20You%20may%20test%20by%20%3DISTEXT(A1)%20or%20like%20from%20any%20empty%20cell.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I have a monthly spreadsheet that will not filter or sort by date.  The column is in date format, the numbers are not imported, I have cleared all filters.  All of the other months I have had no problem, but October will not sort.  I copied the page to a new document and it still won't sort.  Any ideas?

1 Reply

@Pamipj 

Please check if you actually have dates, not texts. To apply date format is not enough if you have texts, texts shall be converted to dates. You may test by =ISTEXT(A1) or like from any empty cell.