TMG-L Archives

Archiver > TMG > 2006-05 > 1146522964


From: "mybones" <>
Subject: Re: [TMG] Numerical dates in excel
Date: Mon, 01 May 2006 18:36:04 -0400
References: <GJENLDADAKODIGLGFCDBKEOKDFAA.kb5wy@carolina.rr.com>


Thanks, Elmo. I'll try that.
Sandy
----- Original Message -----
From: "Elmo Bass" <>
To: <>
Sent: Sunday, April 30, 2006 9:56 PM
Subject: RE: [TMG] Numerical dates in excel


> if u have Access import excel to access and it will sort it properly
>
> Elmo
>
> -----Original Message-----
> From: mybones [mailto:]
> Sent: Sunday, April 30, 2006 3: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 <>.
>
>


This thread: