Custom Sort Column by Time AM PM not working or Bug?

[kellman]

I'm trying to sort the Column by it's date & time AM/PM in order of earlier to oldest.

This was sorting correctly earlier, but now refuses to sort correctly.

Microsoft® Excel® for Microsoft 365 MSO (Version 2211 Build 16.0.15831.20098) 64-bit

It should list the time sorted as this:

8:00 AM
12:00 PM
4:00 PM

Instead I get the following weird order.

Dates with AM PM.xlsm
	A
1	Actual Appt Start
2	12/9/2022 12:00 PM
3	12/9/2022 4:00 PM
4	12/9/2022 8:00 AM
Sheet1

Note: I've tried with Cells formatted as Text and also by Date, no change
Tried Sort A-Z and Z-A and no change.
Rebooted computer with no change.

 

[Micron]

Post 7 worked for me with text.

 

[kellman]

I am completely baffled. Again everything was working earlier today, no software or update changes made.
I was able to sort the Date column without any special formatting previously.
I even installed an older copy of Office 2007 and have the same issue.

I have uploaded a copy here, if you don't mind taking a look:
Date Sorting Example for Mr Excel.xlsx

 

[kellman]

Okay I think that I'm onto something here.
Running Windows 10 current version / build.

I changed Windows 10 Region Date & Time Data Format to match the short date format Date I'm using in my excel project to DD-MM-YY and now I can sort the date column normally!

This time I received the "Sort Warning" dialogue box mentioned earlier, and after clicking the "OK" button, all worked properly as it had earlier this morning.

Struggling to wrap my head around how changing Windows 10 Date Time Data settings made this work, as I never changed anything in the first place.

I hope this helps someone else that might experience this bug.

 

[Peter_SSs]

Glad you got it sorted. Thanks for letting us know.