I am having trouble with Excel 2010 not displaying correctly the date formats. For example, I have the following date format in my database table (dd-mmm-yyyy) and in the related pivot table I get the following date format (mmm-yy). I tried removing the field from the pivot table and then including the field again, but this did not correct the problem. Since I need to choose date specific records in my pivot table, this problem makes it difficult to know which date is being referred to.

Does anyone have any suggestions? Thanks.