I wonder if anyone could help me please? Its probably really simple but I can't for the life of me get Excel to do as I would like.

On all our company graphs/pivots etc, date is displayed as 18/06 (yy/mm) I have tried using a custom format but it always defaults to a full date 01/06/2018 in the display bar even though displaying correctly in the data

05-07-2018 08-32-35.jpg


It causes havoc for my pivots/filters.


How can I have the column format my dates as YY/MM to display in the data and in the display bar?

Please? What is the correct name for the display bar please?

Thank you, Clair