You could calculate the week number to include a prefix, e.g.:

=IF(WEEKNUM(A2)=26,"A-","B-")&TEXT(WEEKNUM(A2),"00")

and the weeks would sort as you want them.

Vincdc wrote:
Hello:
I have a pivot table which is sort by week number 1-52. How can I show the
order as 26-52 and then 1-25.
Thanks in advance!


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