I suspect this is a common problem but none of the solutions I have tried has worked. I am creating a pivot table using powerpivot. The data is coming from another excel spreadsheet in excel 2010. The date column in the data file is formatted dd/mm/yyyy but by the time it gets to the pivot table the format of the date column is general and I cannot change it. Also the format of the date column in powerpivot is also dd/mm/yyyy. The shortdate settings on my computer are dd/mm/yyyy. Any help would be appreciated.