Pivot Table Row Label Date Formating

[Spikenaylor]

I have my pivot table set up

One of the row labels is a date field, however I cannot get it to stay in the date format I wish, it keeps defaulting to dd/mm/yyyy

The source column is set to format dd mmm yyyy.

Every time I try something to change to date format in the pivot table, it defaults back again.

any pointers or help out there.

many thanks

 

[Steph77]

http://www.mrexcel.com/forum/excel-questions/660242-change-date-format-pivot-table.html

 

[Spikenaylor]

Thanks,
The problem was I had 3 fields in the row labels.
I removed 2 of them, then was able to set the date format in the pivot table cells and it remained., put the other two row labels back in and date format remained. great.

Thanks