Hi. This has been a problem on various files for years and I can't seem to solve it. In this case I downloaded bank transactions from a few different banks and removed all but the dates. The format I want them in is month, day , year which would look like 11/04/2021.
I have tried many formatting options but to no avail. The attached sheet Col A has dates from 2020 and 2021 and I am trying to list the earliest at the top. Filters aren't working.
Is there a cure for this never ending battle?
Thank you.
Peter
Bookmarks