In PowerPivot, Dates will show up in Alphabetical order. However, in today’s example, Bill shows us that this particular Data Set has Dates that are stored -not as Dates- but as Text. In Episode #1678, we learn how to work with these Text entries as Dates in PowerPivot.


"PowerPivot For The Data Analysit" by Bill JelenChapter 13…This episode is the video podcast companion to the book, “PowerPivot For The Data Analyst: Microsoft Excel 2010“, from Bill Jelen a.k.a. MrExcel.

For all of your Microsoft Excel needs visit

Your One Stop for Excel Tips and Solutions.