Thread: pivottable date
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Debra Dalgleish
 
Posts: n/a
Default pivottable date

And if they're real dates (not text) sorting may be enough, without
creating a custom list.

Roger Govier wrote:
Hi

Go to ToolsOptionsLists and create a new list of 04/2005, 05/2005,
06/2005 etc.
Go back to the PT, double click on the field, choose Advanced and select
SortAscending again.



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