Greetings,

Quick question. I have a list of data that has dates fromatted in the normal
way, dd/mm/yyyy. I've created a dummy column to give me just mm.

Problem is when i put the info into a pivot table all the data is returned
as dd/mm/yyyy when I need the data to be grouped by month.

Thanks for your help!