Notifications
Clear all
Pivot Tables Quick Start
3
Posts
2
Users
0
Reactions
96
Views
Topic starter
Going through the lessons on pivot tables (5.05 Grouping). I'm having problem grouping dates - the lesson says that this is possibly due to the date format in the source is text and not date . (Yes this is the problem) - Lesson says that there's a link to instructions on how to convert date text to date format but I can see the link . where do I find it?
Thanks
Posted : 14/04/2020 7:03 am
Hi Robert,
The link is at the top of the Grouping sheet in the workbook that comes with the course. Here's the link
https://www.myonlinetraininghub.com/6-ways-to-fix-dates-formatted-as-text-in-excel
Regards
Phil
Posted : 14/04/2020 7:11 am
Topic starter
great - Thanks
Posted : 14/04/2020 10:06 am