I have a large number of spreadsheets with entries based on dates. The
entries have been made by several people using different date formats. IE
2/3/08, 02/03/2008 etc. When I try to sort them they are sorted in clumps
based on the date format entered. When I format all the date cells to show a
specific date format and then ask it to sort by date the entries are still
grouped based on their original date format and not in one complete group as
per the new format shown. Is there any way to fix this without manually
re-entering many of the dates? Thanks.