Kris, Some spreadsheet programs do not recognize dates before 1900 as real dates, so they do not match the format of the more modern dates. Someone once gave me a program that loads with Excel, so that it recognizes all dates. I forget if it was through Legacy, but it may have been, so might be in the Archives.
Does this sound like it may be the real problem - the spreadsheet, rather than Legacy? Susan On 4/29/08, Kris <[EMAIL PROTECTED]> wrote: > I've been lazy entering my dates and never gave it a second thought since > Legacy formats them so beautifully for me. However, I realize now the error > of my ways since I exported to a CSV file and my dates are a mess -- an > accurate mess, but a mess. > > Since the dates were exported in the same way as they were entered, i.e., > MM/DD/YYYY or DD Mon YYYY, whatever felt right at the time, apparently, I > have several different date formats in my CSV file and the spreadsheet I'm > importing it to is giving me dirty looks. > > Is there any easy way to fix this? Or do I just need to go back, fix them > all, and strive for consistency in the future? > > Thanks! > Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp
