This is the most ridiculous thing, but I'm having trouble sorting by date in excel. I have a column of dates that I put in for something, in the following format
And so on like that. However when I try and sort them, it only sorts based on the first number, as I've shown above. When I highlight the data, at the top of window in excel, it doesn't say general anymore it says date so I assume excel knows that they're dates. However if I go to sort and filter to try and choose a few different levels to sort on, when I try to sort by the date it says sort A to Z, which seems odd. Then when I copied and pasted the date column to a new worksheet to play around with it to try and figure out what was wrong, several of the entries turned into hashes, just ######, but only a handful of entries did that and all of them are grouped together.
Does anyone know what could be wrong? This is literally driving me insane, it should be the simplest thing.