Forum Discussion
changing Date format in a pivot table
In the attached file, all I did was:
- Right-click cell A4 and choose "Field Settings"
- Click the Number Format button
- Choose Date category and select "March 14, 2012"
- OK your way out.
thanks,
I tried ... it's not working
I've attached the file in case you want to have a look on it
In the attached file, all I did was:
- Right-click cell A4 and choose "Field Settings"
- Click the Number Format button
- Choose Date category and select "March 14, 2012"
- OK your way out.
I was having the same problem with dates, Ungrouping them worked
JKPieterseI have a pivot table and chart in (current) Office 365 with dates in the row column; when I follow the same steps as described below, there is no "Number Format" button showing in the Field Settings dialog - see screen copy below. Why is that?
I managed to change the date format within the pivot table (using "ungroup"), but this new format does not get reflected in the Pivot Chart. How can I solve this?SergeiBaklan Can you explain more how do you do that?
Thanks
iveccc as far as I am aware of there is no Number Format option for fields in the Row or Filter section. You can only set the formats for the fields in the Column or Values section.
Have you tried to re-organize your data in the way to have Dates field in Column section?
Also it would be good if you can attach your file - to check on you example.
Cheers,
Branka
- Thank you so much ... it's a bit Embarrassing for me .... I don't know why it wasn't working for me
Thank you so much ... it's a bit Embarrassing for me .... I don't know why it wasn't working for me
- Don't be embarrassed, Excel can be confusing!
