Even if you do that, you will see weird stuff in your columns (aside from the prefixes). It just isn’t a 100% good thing. Open Office does a much better job and has no problem with pre-1901 dates. I use Excel for everything else but this.
Michele Simmons Lewis, CG Legacy Family Tree [email protected] <mailto:[email protected]> www.legacyfamilytree.com <http://www.legacyfamilytree.com/> Certified Genealogist is a registered trademark and the designation CG is a service mark of the Board for Certification of Genealogists®, used under license by Board certificants who meet competency standards. From: LegacyUserGroup [mailto:[email protected]] On Behalf Of Cathy Pinner Sent: Monday, June 12, 2017 10:25 PM To: Legacy User Group <[email protected]> Subject: Re: [LegacyUG] Tip of the Day If you are going to be using Excel, the easiest work around for the date issue is to change the date format in Legacy at Options - Customise 5.1 to yyyy-mm-dd and then make the Date columns in Excel Number or Text rather than Date. You still have problems with the prefixes. Cathy Michele/Support wrote: 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] <mailto:[email protected]> www.legacyfamilytree.com <http://www.legacyfamilytree.com> Certified Genealogist is a registered tradema rk 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] <mailto:[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 dat es. 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]/
