Use a helper col to convert the text dates to real dates,
eg: In B2, copied down: = -- A2
where A2 down contains the text dates

Then pivot using col B instead of col A,
and it'll sort correctly in chrono order
(you can format it as date to taste)
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:25,000 Files:370 Subscribers:67
xdemechanik
---
"acss" wrote:
I am trying to create a pivot table of of some small data and when it is
created it unsorts the dates. In my data sheet i have it as January 2008,
February 2008,March 2008 etc yet my columns in the pivot are not in that
order....how can i place them in the correct order?