Greetings,
The attachment has dates that are displayed with a full year -
20/1/2020 and I want to change their design to 20/1/20
I went into custom design and set dd / mm - but the result was not accepted.
Why? What else can you define?
Also, I want when I click Refresh for Pivot -
The row of dates will remain at its normal height and will not change,
How to do it?
Thank you!!
Hi Lea,
You can't format dates in Power Query or PivotTable row/column areas. They are fixed formats based on your region settings.
Row heights shouldn't reset on refresh. I made the rows bigger in your file and they didn't change on refresh, so I wasn't able to reproduce this.
Mynda
Thanks for the response.
About 1/2/20 - where can I change my area settings -
To influence the date design in Pivot?
Hi Lea,
Sorry, I should have been clearer, you can only change whether your dates are dd/mm/yyyy or mm/dd/yyyy. You can't set it with a two digit year, which is what I thought you were after. You'll find it in your Windows date and time settings.
Mynda
