I have a table with dates in **Column A** (and they are dates and recognized and stored in memory as dates by Excel)

Proof that Excel (2016) is recognizing them as dates, I tried converting the value to a date with a `DATEVALUE()` call, but it shows that the value is stored in memory as an Excel date:

[![Proof of Date Recognition](https://i.stack.imgur.com/Uj9m8.png)](https://i.stack.imgur.com/Uj9m8.png)

This is the terrible sort that Excel is choosing when I attempt to sort by Oldest/Newest by right clicking on a "10-Jun" field:

[![Excel Incorrect Sort](https://i.stack.imgur.com/O0b7u.png)](https://i.stack.imgur.com/O0b7u.png)

Another issue/bug/side-effect is that when I attempt to change the format, it ignores my changes.

[![Choosing Date Format Example](https://i.stack.imgur.com/BaZL6.png)](https://i.stack.imgur.com/BaZL6.png)

This issue is very odd and I'm not sure if I found a bug in Excel, however it's currently ruining my graphs. :(