On Wed, 13 May 2009 09:48:08 -0700, SCH wrote:

How do I set my Excel to Always sort dates in the following format by Year,
Month, and Day? My current setting sorts by Month, date, and then year.
For example my setting is sorting as follows:
01/19/09
02/01/08
02/17/08
etc.

Most likely your data is stored as TEXT rather than as dates.

To prove this, =ISNUMBER(cell_ref) will give FALSE (if they are stored as dates
it should return TRUE).

To correct this, you can try:
select a blank cell
edit/copy
select your range of dates
edit/paste_special/add

The values may change to 5 digit numbers. Just select to format them as dates.

Now they should sort.

If this does not work, there may be extra characters within the cell.
--ron