If you are able to sort dates correctly in Excel then you are using a workaround/add on. You have to use a workaround and most of these are too advanced for the average user. I tested this again recently using Excel 365 which is their most updated version. I could not sort the dates and the dates were all mangled.
Michele Simmons Lewis, CG Legacy Family Tree [email protected] www.legacyfamilytree.com Certified Genealogist is a registered trademark and the designation CG is a service mark of the Board for Certification of GenealogistsR, used under license by Board certificants who meet competency standards. -----Original Message----- From: LegacyUserGroup [mailto:[email protected]] On Behalf Of Pete Beatty Sent: Monday, June 12, 2017 10:36 AM To: Legacy User Group <[email protected]> Subject: Re: [LegacyUG] Tip of the Day Michele, your current tip contains the following: "Excel can't handle pre-1901 dates so you will have a problem sorting by columns." Excel Does not have a problem with dates prior 1901. It can handle all formats of dates. I have several spreadsheets with some having thousands of records with dates ranging between 0900 and present. I can sort, and filter all records correctly. Perhaps you are referring to dates with prefixes. We sometimes think items such as "bef" Or "c" as dates. Technically they are not components of a date. When you add them to a date, they are interpreted as a character string, not a date. As a character string, the entries are not sorted as a date. If this is the case, then excel can still properly sort. You may have to define a format, a relatively simple process, or perform a simple cleanup. Pete -- LegacyUserGroup mailing list [email protected] To manage your subscription and unsubscribe http://legacyusers.com/mailman/listinfo/legacyusergroup_legacyusers.com Archives at: http://www.mail-archive.com/[email protected]/ -- LegacyUserGroup mailing list [email protected] To manage your subscription and unsubscribe http://legacyusers.com/mailman/listinfo/legacyusergroup_legacyusers.com Archives at: http://www.mail-archive.com/[email protected]/
