sorting using dates
 

when I sort dates. the results are NOT appearing in
order. Such as 01/15/02; 01/20/02; 02/15/03; 01/05/01; -
it will sort with my 02/15/03 after my 01/15/02 instead
at the very end. How do I fix.

Thank you.

Make sure all dates are numbers. if 01/15/01 sorts last ascending it must be
text which is greater than numbers, copy an empty cell, select the cell with
01/15/01,
do editpaste special and select add, if it changes to 36906 then reformat
as date

Regards,

Peo Sjoblom

"Tpason" wrote:

when I sort dates. the results are NOT appearing in
order. Such as 01/15/02; 01/20/02; 02/15/03; 01/05/01; -
it will sort with my 02/15/03 after my 01/15/02 instead
at the very end. How do I fix.

Thank you.