Re: Sorting problem
From: Norman Harker (njharker_at_optusnet.com.au)
Date: 02/12/04
- Next message: Popandopolo: "macro: merge, wrap text, left justify and auto-fit"
- Previous message: Harlan Grove: "Re: Trend() worksheet arguments"
- In reply to: Pam Graham: "Sorting problem"
- Next in thread: Pam: "Sorting problem"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 13 Feb 2004 08:54:47 +1100
Hi Pam!
I suspect that it is sorting correctly but there might be problems
with the Regional Options setting for the double digit year
interpretation.
Before or after sorting, check your dates are what you think they are
by formatting (e.g.) dd-mmm-yyyy
If they are correct and you still have problems report back. If they
are not correct then there may be ways of correcting with formulas
after establishing the default double digit year interpretation.
-- Regards Norman Harker MVP (Excel) Sydney, Australia njharker@optusnet.com.au Excel and Word Function Lists (Classifications, Syntax and Arguments) available free to good homes. "Pam Graham" <anonymous@discussions.microsoft.com> wrote in message news:ef8f01c3f1b1$98aac660$a301280a@phx.gbl... > I'm trying to sort a list by year. > When I sort, the results sort in two parts -The first part > is sorted from 1938 to 2003 and the next is sorted 1930-2003. > > How do I get the listed to sort properly? >
- Next message: Popandopolo: "macro: merge, wrap text, left justify and auto-fit"
- Previous message: Harlan Grove: "Re: Trend() worksheet arguments"
- In reply to: Pam Graham: "Sorting problem"
- Next in thread: Pam: "Sorting problem"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
