Forum Discussion
Solved
Custom Sorting - can you apply it to filters?
I have a column which is Week number (based on WEEKNUM calculation). Excel reads this as a text field and so Week 1 is arranged after Week10 etc. To fix this in the table I created a custom sort list. However when i apply filters to the table, Week 10 is still listed above Week 1, and the same on pivot tables.
Is there a way to change this?
If you return Week Number as
="Week " & WEEKNUM(E7,2)you may use
="Week " & TEXT( WEEKNUM(E7,2), "00" )instead
