I have imported dates in an excel spreadsheet from WinQs.sql and opened the file in excel.
the date format is 07/11/2009 but I want to change the date to filter it. Filtering as it is, filters according days first then months. I would like to filter it in exact dates. 2009/11/07, does just that.
My preblem is either with the filtering or changing the date.