NYDUTCHE-L Archives

Archiver > NYDUTCHE > 2003-08 > 1060207603


From: Ginny Buechele <>
Subject: Re: [NYDUTCHE] Spreadsheet Formatting of Genealogical Dates
Date: Wed, 06 Aug 2003 18:07:57 -0400
References: <001b01c35c5d$d9a2e0b0$6500a8c0@cl3072370a>


Thanks Jess it seems to be working for me now.
Perhaps the other day I was working with an imported file and that made
the difference.
Anyway it seems to be working for me now.
Thanks for the reply
----- Original Message -----
From: "Jess Wallace" <>
To: <>
Sent: Wednesday, August 06, 2003 5:01 PM
Subject: RE: [NYDUTCHE] Spreadsheet Formatting of Genealogical Dates


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



==== 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: