In EXCEL (and I assume OOffice) - you should be able to pick a column - and SET CELL FORMAT. I have done it in the past.. at least I think I have..... Keith
On Tue, Apr 29, 2008 at 11:14 PM, Kris <[EMAIL PROTECTED]> wrote: > Yes -- the CSV file was generated by Legacy. Here are a few of lines from > it: > > Abernathy, Clayton [246] Mar 1891 > Adams, Marie [199] 11/11/1806 05/11/1884 > Adkins, Andrew Jackson [635] 08/29/1856 06/13/1932 > Adkins, David [637] Jun 1854 10 March 1905 > Adkins, Della May [393] 03/08/1896 10/31/1982 > > These dates display in the "DD MMM YYYY" format, however, in Legacy. > > I'm beginning to think I'm just jinxed. > > > > On Tue, 29 Apr 2008 21:50:13 -0500, JLB <[EMAIL PROTECTED]> wrote: > > > > This CSV file you're talking about: Is it generated by Legacy and > therefore based on your date settings there? I don't think it's possible to > get a csv output in some other format than what Legacy is set for. So I'm > trying to imagine what else is going on there. I"ve tried entering dates in > different formats, watching Legacy correct them and then looking for a > 'mess' in a csv file. There just isn't one. > > -- > > JL > > JLog - simple computer technology for genealogists > > http://www3.telus.net/Jgen/jlog.html > > > > Kris wrote: > > > > > Thank you to everyone who responded, but once again, I apparently was > not clear. > > > > > > I have Legacy set to display dates as "29 Nov 1847." I can enter > "11/29/1847" and it will format the date as per my settings, i.e., "29 Nov > 1847." However, the date is apparently stored as "11/29/1847"in Access and > in the CSV file it is displayed as "11/29/1847." > > > > > > Because I have been inconsistent in my data entry, since no matter how I > entered it the date was displayed as per my options, I have a mess of > different formats in the CSV file, i.e., "24 June 1843", "02/04/1947", > "February 23 1845." > > > > > > I'm using OOo's Calc, not Excel, and it isn't having any problem with > the years -- they are displayed as I entered them originally. > > > > > > On Tue, 29 Apr 2008 16:27:52 -0500, Brian Johnson <[EMAIL PROTECTED]> > wrote: > > > > > > > > > > Or use Calc which is the OpenOffice spreadsheet. It has no problem > with dates. > > > > > > > > Brian > > > > > > > > > > > > 2008/4/29 Don Brown <[EMAIL PROTECTED]>: > > > > > > > > > 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 > > > > > > > > > > > > > > > > > > > > > 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 > > > > > > > > > > > > > > > > > > > > > > > > > > > > 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 > > > > -- Surnames: McKain, Horn, Riale, Ulrich, Erisman, Leiphart, Reed and Henry Website: http://home.comcast.net/~geosci64 EMail: [EMAIL PROTECTED] McCain-McKane-O'Kane DNA Group 1 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
