Log In
Register
Home
March 10, 2016
Offline
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!!
See Answer
July 16, 2010
Offline
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
March 10, 2016
Offline
Thanks for the response.
About 1/2/20 - where can I change my area settings -
To influence the date design in Pivot?
July 16, 2010
Offline
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
Answers Post
1 Guest(s)
