NYDUTCHE-L Archives

Archiver > NYDUTCHE > 2003-08 > 1060203662


From: "Jess Wallace" <>
Subject: RE: [NYDUTCHE] Spreadsheet Formatting of Genealogical Dates
Date: Wed, 6 Aug 2003 16:01:02 -0500
In-Reply-To: <000f01c35c5b$53dd57a0$0a00a8c0@Main>


I use Excel all the time, so I pulled up a spreadsheet and entered dates
from the 1800's in a couple different formats and I had no troubles. Try
going into "Format" "Dates" and look at your settings.

Jesse Wallace
Rochester, MN

-----Original Message-----
From: Ginny Buechele [mailto:]
Sent: Wednesday, August 06, 2003 3:43 PM
To:
Subject: [NYDUTCHE] Spreadsheet Formatting of Genealogical Dates


I'm wondering if any one out there can help me in regard to formatting dates
prior to 1900 in Excel. It appears that Excel is set up to only work with
dates after 1900, formatting of dates prior to 1900 adds 1900 to the year
input i.e. 1873 becomes 3773. Does anyone know of the formula I can use for
inputing dates prior to 1873 that will make them display correctly. I need
to be able to do this to input the Dutchess County Poorhouse death data I
am collecting and have it display, sort etc. correctly.

Is there any Web Design Program that will read/import in html an .xls file
or do all tables have to be created in an html program. I want to get the
Poorhouse Data I have collected organized, sortable and uploaded in a table
format in as few steps as possible.
Any suggestions appreciated.

This may not appear to be related to Dutchess County Genealogy but once I
can accomplish this it should be of benefit to many in the Genealogical
Community.

Thanks
Ginny
Ginny's Genealogy Page
Dutchess County Tombstone Inscriptions & MORE!
Help Save A Cemetery & A Piece of Dutchess Co. History
http://www.geocities.com/Heartland/Acres/2843/saveacemetery.html
"Show me your cemeteries, and I will tell you what kind of people you have."
Benjamin Franklin
"What had had meaning for millennia should not be destroyed or defaced for
transient profit.''
Frances Stevens Reese - 1997



==== NYDUTCHE Mailing List ====
This list is currently being administrated by D. Joshua Taylor For help
contact him at

==============================
To join Ancestry.com and access our 1.2 billion online genealogy records, go
to: http://www.ancestry.com/rd/redir.asp?targetid=571&sourceid=1237


This thread: