I am responding to an old post about problems with dates that sort like they
are text. I too have gone back to the source and reformated as dates and
tried to rerun the pivot tables. I even reran them without using a previous
table so the formatting wouldn't carry over.

I also tried the edit replace suggestion (from Contextures), using "/" in
the Find and "/" with the replace and it states that it didn't find the
records with "/".

Once I get the dates sorted, I wanted to group the dates in 3 month
increments, significantly reducing the number of columns in my table. Any
ideas that don't involve VBA would be appreciated.

Ken

"Debra Dalgleish" wrote:

Excel is probably seeing the dates in the source table as text. There
are some techniques here that you can use to convert the text to dates,
so they can be sorted correctly:

http://www.contextures.com/xlDataEntry03.html

Todd1 wrote:
I have used pivot tables quite a bit in the last year.
I have a pivot table with dates and can't get the sorting to work the way I
would like. I want it to sort in ascending or descending order, but it is
sorting like this:
9/19/2005
9/2/2005
9/20/2005
9/21/2005
9/23/2005
9/3/2005
9/4/2005
I have tried formatting the data source, and it is formatted using the
mm/dd/yyyy format.
Can anyone help? I would even be willing to send you the excel workbook if
needed.

Thanks. Todd



--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html