How can we help?
How to get rid of 0-Jan-00 dates in my Pivot table?
- Right-click on the field in the Pivot table layout.
- Select “Format cell”.
- Select “Custom Format” on the right and enter ‘d-mmm-yy;;‘ (Please note the double semi-colons are the key).