TMG-L Archives

Archiver > TMG > 2006-05 > 1146523000


From: "mybones" <>
Subject: Re: [TMG] Numerical dates in excel
Date: Mon, 01 May 2006 18:36:40 -0400
References: <20060501172132.TLHJ17701.ibm67aec.bellsouth.net@MomsLaptop>


OK. great. I'll try it.
Sandy
----- Original Message -----
From: "Teresa Elliott" <>
To: <>
Sent: Monday, May 01, 2006 1:26 PM
Subject: RE: [TMG] Numerical dates in excel


> Yes, just have the Year of the field you want sorted in a separate column.
> When you set up the file, you can put in OUTPUT Columns. One of the options
> should be Year.
>
> Teresa Ghee Elliott-IBSSG
> TMG sentences
> http://freepages.genealogy.rootsweb.com/~rutherfordcemetery/TMG%20census%20t
> emplates/TMG.html
>
>
> -----Original Message-----
> From: Jill Morelli [mailto:]
> Sent: Sunday, April 30, 2006 8:48 PM
> To:
> Subject: RE: [TMG] Numerical dates in excel
>
> I do what Teresa mentioned. It takes up a line of the output possibilities
> but I leave it to the end and then never print it. I then put it primary
> (i.e. with the no. 1 in the left side of the field for "sort by...")
>
> I believe the word is "Year" but if you can't find it, or I have
> misunderstood the issue, let me know.
>
> Jill
>
> -----Original Message-----
> From: Teresa Elliott [mailto:]
> Sent: Sunday, April 30, 2006 1:04 PM
> To:
> Subject: RE: [TMG] Numerical dates in excel
>
> Sandy,
> When I do it, I make one of my output columns be the Year. Then I do the
> sorting in Excel.
>
> Teresa Ghee Elliott-IBSSG
> TMG sentences
> http://freepages.genealogy.rootsweb.com/~rutherfordcemetery/TMG%20census%20t
> emplates/TMG.html
>
>
> -----Original Message-----
> From: mybones [mailto:]
> Sent: Sunday, April 30, 2006 2:51 PM
> To:
> Subject: [TMG] Numerical dates in excel
>
> Hi-
> I wanted to send a List... report to Excel and sort by date. I went to
> Preferences and changed the date format from my usual dd Mmm yyyy to
> yyyy.mm.dd so it would sort earliest dates first, etc. It changed the format
> in the person view, but the Excel chart still sorted 1 Jul 1856, 1 Jun 1845.
> Is there a way to be able to sort by year-month-date?
> Sandy
>
>
>
> ==== TMG Mailing List ====
> To un-subscribe from TMG-L (in MAIL mode), send a message to
> <> [to <> in Digest mode
> or to in Index mode] with just the word
> "unsubscribe" (no quotes)in the text and turn off your signature.
>
>
>
>
> ==== TMG Mailing List ====
> Send all messages and replies to <>.
>
> --
> No virus found in this incoming message.
> Checked by AVG Free Edition.
> Version: 7.1.385 / Virus Database: 268.5.1/327 - Release Date: 4/28/2006
>
>
> --
> No virus found in this outgoing message.
> Checked by AVG Free Edition.
> Version: 7.1.385 / Virus Database: 268.5.1/327 - Release Date: 4/28/2006
>
>
>
> ==== TMG Mailing List ====
> Send all messages and replies to <>.
>
>
>
>
> ==== TMG Mailing List ====
> The Wholly Genes FAQ page <http://www.whollygenes.com/faq1/fom-serve/cache/1.html>; has information not only about TMG and how to obtain it, but helpful hints on using it.
>
>


This thread: