Date Sorting for FP

[ItsATeam]

How can I format the dates on a sheet from this "2016 Week 1" to this: "2016 Week 01" instead of doing a control find and replacing the 1 to a 01. I want the dates in that order so when I do the pivot table update, it has them in order instead of week 1 and then week 10.

 

[RMS123]

When you replace check "Match entire cell contents" located in the options. this will prevent the other one from changing.

Regards.