I have this dowloaded spreadsheet with a column of dates.
The dates are not in a format that allows for proper sorting.
The format is like this: 18/APR/2012
i forced the format as as a date but still can not get it to sort properly.
It will only sort the Days and not the month or year.
meaning a list would be sorted ascending like this:
]Notice the days sort ascending but it should be sorted beginning with year 2011 but notice it is last and not first.
Is there an easy way to modify the column to format it correctly to allow for proper sorting?