Custom Sorting - can you apply it to filters?

[stacey197]

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?

[#2 · Accepted solution]

@stacey197 

If you return Week Number as

="Week " & WEEKNUM(E7,2)

you may use

="Week " & TEXT( WEEKNUM(E7,2), "00" )

instead

[#3]

Ah yes that worked perfectly, thank you for your help!! :)

[#4]

@stacey197 , you are welcome