I have a worksheet with a column for dates. The dates are entered in format dd/mm/yyyy. I would like to sort the dates in chronological order, however, the dates are all in the 18th century i.e. 01/01/1750. Excel does not want to sort these dates at all. I have also tried to format the column the dates are in so they show as 01-Jan-1750, but that won't work either. Is there a date limitation in Excel. I am using Excel for Mac 2011. TIA
Bookmarks