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.

[youtube=http://youtube.com/watch?v=CfWpUhrKCjs]

"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 MrExcel.com

Your One Stop for Excel Tips and Solutions.