Forum Discussion
sort data by date
The date-and-time format is based on what you can find under "Custom" cell format, with a slight modification. If you can't see the particular one that I used, you can just type "yyyy/mm/dd hh:mm" in the field where it says "Type:". The picture below may clarify it. Be it that I'm on a Mac and your screen may look a different in case you are on a PC.
Riny_van_EekelenI have done everything as you said but still stays as "text". The filter is asking either
A to Z or Z to A not "oldest" or "newest"
regards
graham leoThe idea of saving in a Excel Workbook rather than a csv format was a serious negative outcome for me. The information saying by saving in csv format you will lose features is MIS-information.
I don't know what features they are talking about, all I know is Microsoft cause me a lot of frustration for months on end. What I have now is, my data when downloaded no work/ modification on the dates format is required, I can start on the Analysis of my data immediately. Thanks for nothing Microsoft, maybe I should be entitle for a refund at least, you would not be able to put a figure on the productivity.
Riny_van_Eekelenhello Riny,
Now have an immediate positive outcome.
As you suggested I kept it in "csv" format and changed the settings in the system to UK rather than Australian format (not to sure about that one because it appears to be similar).
thanks and regards
Strange! Took your original file, re-did, text-to-columns as described, and applied the custom format.
On my system I can sort oldest to newest when I go via Data / Sort. However, when I sort via the the Filter button, like you describe, it only allows for Ascending or Descending. But the fact that it has "grouped" the data by 2020 and 2019 tells me that Excel is recognising real dates.