Pivot Table not sorting Columns with Week # correctly

[dianne_g]

This is driving me nuts... I have been searching online and can only find info for rows, not columns. Only 1 week is out of order....

I have attached 2 pics showing the formula for week #, how it looks on sheet, and showing week 45 at the end of all the weeks.

What do I need to do to get that 45 where it belongs?

Thank you for your help! Appreciated!

 

[Special-K99]

I reckon that cell with 45 in it is text.

 

[dianne_g]

I reckon that cell with 45 in it is text.

How could that happen? i am using the WeekNum formula shown on first image in formula box..... and when i right click to format that cell it shows as number, like the others

 

[dianne_g]

i ended up re-creating the table.. And now, the week numbers are sorting correctly.... so not sure why or how it happened, but its good to go now...