@legacyfamilytree.com
Subject: Re: [LegacyUG] Date Formats in CSV
From: [EMAIL PROTECTED]
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
://www.fergys.co.uk/Grimshaw/
For The Fergusons of N.W. England See:
http://myweb.tiscali.co.uk/fergys/
_
Date: Tue, 29 Apr 2008 21:19:33 -0500
To: LegacyUserGroup@legacyfamilytree.com
Subject: Re: [LegacyUG] Date Formats in CSV
Kris wrote
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.
I have just been able to replicate your problem, but also solve it.
Once you have opened your .csv file in the spreadsheet, highlight the
date
/
_
Date: Wed, 30 Apr 2008 01:54:04 -0500
To: LegacyUserGroup@legacyfamilytree.com
Subject: Re: [LegacyUG] Date Formats in CSV
From: [EMAIL PROTECTED]
Hi, Ron --
You aren't dense at all. As a matter of fact, you've hit the exact
point. That *is* the way I actually entered the dates -- i.e.,
11/24
of N.W. England See:
http://myweb.tiscali.co.uk/fergys/
_
From: [EMAIL PROTECTED]
To: legacyusergroup@legacyfamilytree.com
Subject: RE: [LegacyUG] Date Formats in CSV
Date: Wed, 30 Apr 2008 10:27:36 +0100
Sorry, Kris but I
Subject: RE: [LegacyUG] Date Formats in CSV
Date: Wed, 30 Apr 2008 11:20:54 +0100
Kris,
For some reason best known elsewhere, the last part of my previous email was
curtailed and should have read:
This is the sentence I do not get:I now have, basically, garbage for dates
in my CSV file
If it is that important (which you stated it's not, but if it does
become so...) add a few extra columns in your excel file (assuming you
opened csv in Excel for this) to the right of the problem child
column, and then from your menu bar select [Data] [Text to Columns].
**Make sure you have enough
Sent: Tuesday, April 29, 2008 2:27 PM
To: LegacyUserGroup@legacyfamilytree.com
Subject: Re: [LegacyUG] Date Formats in CSV
This is my experience: All dates entered in the Individual information
screen will be a consistent format which you can choose under
Customize/Dates. If you haven't chosen
This is my experience: All dates entered in the Individual information
screen will be a consistent format which you can choose under
Customize/Dates. If you haven't chosen anything it will be doing
something anyway by default. You can change the format on all of them
at the click of a
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
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
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
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/1847in Access
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. Ive
tried entering dates in
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
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
16 matches
Mail list logo