This issue came up a while ago. Visit http://j-walk.com/ss/excel/files/xdate.htm and check out a file called "XDate". This small program adds new functionality to Excel 97 and later.
-- Don Brown Orangeville, Ontario, Canada > -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Kris > Sent: Tuesday, April 29, 2008 2:02 PM > To: [email protected] > Subject: [LegacyUG] Date Formats in CSV > > 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/[email protected]/ > Online technical support: http://www.LegacyFamilyTree.com/Help.asp > To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages: http://www.mail-archive.com/[email protected]/ Online technical support: http://www.LegacyFamilyTree.com/Help.asp To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp
