I have an HTML document with a table in it. The table includes a date column with dates in MM/YYYY format.
I’m able to open the document in Calc and save it as .ods but whether or not I check the “Detect special numbers (such as dates)” box when importing it I cannot figure out how to make that column behave as a date.
I have formatted the column as Date and I have tried Text to Columns to specify a date format, but sorting by the column in ascending order still seems to treat it as text:
10/2001
10/2002
10/2003
11/2001
11/2002
11/2003
12/2001
etc.
I feel certain I must be overlooking something obvious. How do I get Calc to recognize these as MM/YYYY dates?