Hi all,

I have a worksheet of data, one column of which is date (dd-mmm-yyyy). For
Pivot table purposes I want to extract mmm and yyyy into seperate columns. I
have no problem with this. However, if I included these columns in a pivot
table I have multiple record entries for the same mmm and yyyy. Scrolling
over each of them it appears they are unique as for some reason a 24Hr time
stamp is included : (

Any ideas how to resolve this?

Don-