My Raw Access files come to me from cPanel with their dates in the form
DD/MMM/YYYY as
in 01/Apr/2018. I am now facing a spreadsheet of 5000+ rows and A through O
columns which
I would like to sort in day-to-day order, Day 1 through Day 31, for example.
What I am
getting instead is 01/Jan/2018, 01/Feb/2018. etc. which isn't a rational
sort.
I've drawn a complete blank in my efforts to convert DD/MMM/YYYY to
MM/DD/YYYY, except
by doing it longhand, which is tedious.
If either one of these puzzles can be solved, I will be happy, as I can
indeed sort on
the date when it is in the format MM/DD/YYYY, which is all numbers.
Thanks,
George Langford
