pivot table group day

[magnus101]

I have excel 2010.

In a pivot table, when you group by days, the format seems to go to dd-mmm.
Even if the original data is formatted as dd/mm/yyyy.
Excel then won't let you change the cell format in pivot table.

Is there a way to get the full dd/mm/yyyy in a grouped pivot table?

thanks