pivottable does not sort date values?

[Robert Koster]

Anyone know why excel 2000 does not sort date values?
it lists in the following way:

01-2001
01-2002
01-2003
02-2001....

or

2001-01
2001-10
2001-11
..·..

 

[Allen]

Yes. Your dates have been input as text. It is simply
sorting them by alphabetical order.

Go back to your original data and find the column with the
dates. Create a new column and use =datevalue(a1) where
a1 is the reference to the cells with the misinterpreted
dates. Display the cells in the new column as dates.
Now recreate your pivot table including this new column
and you will find you will be able to sort it by these new
dates.

Allen

 

[Robert Koster]

thank you! though not very straightforward, it worked
finally