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.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Date Sorting for FP
- Thread starter ItsATeam
- Start date
-
- Tags
- dates and text
