pivottable does not sort date values?

R

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
..·..
 
A

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
 
Top