GOONS-L ArchivesArchiver > GOONS > 2006-03 > 1141382758
From: "Joan Vinall" <>
Subject: Re: [G] Excel and dates before 1900
Date: Fri, 3 Mar 2006 10:47:45 -0000
References: <002a01c63e1b$654bbfa0$220110ac@JIMSIDEQ> <email@example.com>
I am coming in a bit late on this, but I have transcribed many a Parish
Register by using separate columns for year and date.
Excel then sorts the year column as a number and and the date and other
columns follow when sorting. This may be a 'cop-out' but it works.
The only problem remaining is the year ending change from early April to
January 1st! I haven't cracked that one.
|Re: [G] Excel and dates before 1900 by "Joan Vinall" <>|