Has anyone worked out how to make Excel sort a column of dates into an ascending order??
There seems to be a default (explained in the Help section) to start the list at 1900-01-01. I want it to start at my earliest date which is 1659-03-25.
When I sort the data by the date column I get all the 1900s up to 1999 first and then it starts on 1659 up to 1899.
Its driving me nuts :(
Anne
There seems to be a default (explained in the Help section) to start the list at 1900-01-01. I want it to start at my earliest date which is 1659-03-25.
When I sort the data by the date column I get all the 1900s up to 1999 first and then it starts on 1659 up to 1899.
Its driving me nuts :(
Anne
Comment