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.
Chapter 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.