Legacy users, this is pretty much off topic to you. Feel free to skip. Susan-
Excel cannot normally recognize dates prior 1900. For most of us, this is fine. We want to use current or nearly current dates. For us serious genealogists, this is grave! No pun intended. I use dates prior to 1900, by using an add-in. If you are like me and want to use prior to 1900 dates, this suggestion works for me. Use XDATE functions. Read about them here: http://j-walk.com/ss/excel/files/xdate.htm It is free, and I love it. Robert -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Susan Daily Sent: 2006-09-14 09:28 To: [email protected] Subject: Re: [LegacyUG] Date entry bug, i.e. 1900-07 Thanks for that Robert! Maybe my change over occurred when I went from Windows ME to my new laptop with XP. I just did some testing in Legacy, and when I type 1930-36 it correctly changes it to 1930-1936. I moved my date setting back to 1911-2010. This will be good to know, too, when I work with dates in Excel. For some reason, Excel won't sort by 1800 and 1900 years - doesn't recognize them very well. So this may help me out a lot! Thank you, Susan On 9/13/06, Robert Carneal <[EMAIL PROTECTED]> wrote: > Don't forget Windows Regional and Language Options plays a role in how > Legacy interprets this. To find this on XP machines, go to Start >> Control > Panel >> Regional and Language Options. > > On my machine, under the tab "Date," there is a 'Calendar' setting. It says > when I two-digit year is entered; it is to be interpreted as a year between > 1930 and 2029. > > Therefore, if the year entered is "59" it should be taken as 1959. If the > year entered is "22" it should be taken as 2022. > > Robert Legacy User Group guidelines can be found at: http://www.LegacyFamilyTree.com/Etiquette.asp To find past messages, please go to our searchable archives at: http://www.mail-archive.com/[email protected]/ For online technical support, please visit http://www.LegacyFamilyTree.com/Help.asp To unsubscribe please visit: http://www.LegacyFamilyTree.com/LegacyLists.asp
