I have Excel 2007. Re-formatting the entire column is not an option, as dates that are year only (for example, 1965) get messed up.
Mary -----Original Message----- From: Jerry [mailto:jerrysemailgro...@gmail.com] Sent: Monday, February 27, 2012 10:00 PM To: LegacyUserGroup@LegacyUsers.com Subject: Re: [LegacyUG] Dates in CSV file What version of Excel are you using? The newest versions will alow you to format dates with 4 digits for the year. Highlight or select the entire column, go to Format cells, select the number tab, select Date and then select the specific format you want. I hope this helps. Jerry "M. Brenzel" <brenze...@roadrunner.com> wrote: >I have created a CSV file from the Name List containing Surname/Given >Name, Living Indicator, Birth Date, and Death Date. When I look at the >file in Notepad, the dates look good. But when I open it in Excel, >some of the dates are formatted differently than most of the others. > >For example, the date 1 Sep 1913 in Legacy looks the same in Notepad >but in Excel, it is displayed as 1-Sep-13. When I look at the table in >Access (tblIR), the dates look different than those that are correct. > >Does anyone have an idea why the dates are "messed up" for some people >but not others? And is there an easy way to fix them? > >Thanks, >Mary > Legacy User Group guidelines: http://www.LegacyFamilyTree.com/Etiquette.asp Archived messages after Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyusers.com/ Archived messages from old mail server - before Nov. 21 2009: http://www.mail-archive.com/legacyusergroup@legacyfamilytree.com/ 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
