I have code that brings data in a database to Excel.
For it to be versatile the cells are formatted as "General". This worked.
Now someone wants to sort dates "Oldest to Newest" but the only option that shows up is A to Z or Z to A.
I followed all suggestions found in How to sort by dates excel?. Going through all those steps I did see the proper sort appear, so I recreated the workbook to reproduce this but could not.
Why doesn't formatting the column as a date display the "Oldest to Newest"?
What steps are required to get the sort options to display "Oldest to Newest"?
I press F2 and it does not work. I click on a cell in the original column that was general changed to date but it does not work. I click on the column header in the original column that was general changed to date but it does not work. I click on a cell in the new column that pasted values special but it does not work. I click on the column header in the new column that pasted values special but it does not work.