SOUTH-AFRICA-L Archives

Archiver > SOUTH-AFRICA > 2004-06 > 1086311041


From: "Steve Hayes" <>
Subject: Re: [ZA] Sorting by date order in MSWord and Excel
Date: Fri, 4 Jun 2004 03:04:01 +0200
In-Reply-To: <001901c44971$023b7680$17880fc4@eileen>


On 3 Jun 2004 at 15:42, Eileen & Marty Russell wrote:

> Hi
> I am trying to put some lists in date order and I can't get either Word or
> Excel to do it properly, there is probably a trick but I can't find any clues
> in the Help facility or in the book I've got.
>
> Here's what happens, if I type the dates in the style 6 Oct 49 or 10/5/56 it
> works fine. As soon as I put the year in full e.g. 6 Oct 1849 or 10/5/1856
> it doesn't work any more. This, of course, is totally useless for my needs as
> I must have the century. Can any one help me?

Try the international (and South African) standard: 2004-06-03

--
Steve Hayes
E-mail:
Web: http://www.geocities.com/Athens/7734/stevesig.htm
Phone: 083-342-3563 or 012-333-6727

This thread: