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/legacyusergroup@legacyfamilytree.com/
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/legacyusergroup@legacyfamilytree.com/
Online technical support: http://www.LegacyFamilyTree.com/Help.asp
To unsubscribe: http://www.LegacyFamilyTree.com/LegacyLists.asp
