GOONS-L Archives

Archiver > 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> <6.2.1.2.2.20060302192639.0294b630@195.102.249.132>


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.

Joan Vinall

This thread: