Pivot Table Row Label Date Formating

Spikenaylor

Board Regular
Joined
Apr 14, 2013
Messages
107
Office Version
  1. 365
Platform
  1. Windows
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
 

Some videos you may like

Excel Facts

Return population for a City
If you have a list of cities in A2:A100, use Data, Geography. Then =A2.Population and copy down.

Spikenaylor

Board Regular
Joined
Apr 14, 2013
Messages
107
Office Version
  1. 365
Platform
  1. Windows
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
 

Watch MrExcel Video

Forum statistics

Threads
1,108,999
Messages
5,526,167
Members
409,685
Latest member
Bellybb

This Week's Hot Topics

Top