Excel doesn't recognize pre-1900 dates. There is an add-in called X-Date which allows Excel to recognize them. You can download it from
http://j-walk.com/ss/excel/files/xdate.htm Dates from Legacy will never sort correctly in Excel because we have them entered in so many different ways: day month month year day month year year only along with the date prefixes Excel just doesn't sort those as we would want them sorted. I've asked the programmers if they could export dates in CSV so they would all be yyyy/mm/dd because that's the only way you'd get a good sort. If there's no year, month or date, then they could put 00 in that field. They'd need to keep the date prefixes and I'm not sure how Excel would handle those. Sincerely, Sherry Technical Support Legacy Family Tree On Sat, Jan 28, 2012 at 8:46 AM, Paula Ryburn <[email protected]> wrote: > Derek and others, > I've run this (the spreadsheets look great) but it seems that any dates > after 1900 are in MM/DD/YYYY format, while those before 1900 are in > YYYY/MM/DD format. Can anyone think of a reason why they would come out of > Legacy that way? Messes with sorting, obviously. > > --Paula in Texas Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages after Nov. 21 2009: http://www.mail-archive.com/[email protected]/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/[email protected]/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp Follow Legacy on Facebook (http://www.facebook.com/LegacyFamilyTree) and on our blog (http://news.LegacyFamilyTree.com). To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp
