radonwilson
Board Regular
- Joined
- Jun 23, 2021
- Messages
- 50
- Office Version
- 2019
- Platform
- Windows
Using power query, I changed this date & time format 01-Nov-2022 2:18:19 pm UTC to this 01-11-2022 date format.
And once, I loaded this query data to the Pivot table I got the date formatted as 44866 (a 5-digit number).
I want dd/mm/yyyy date format and I also tried to get the desired format by right-clicking one of the date field items in the pivot table and changing its format to dd/mm/yyyy but It did not update all the cells.
Why its happening and how to fix?
And once, I loaded this query data to the Pivot table I got the date formatted as 44866 (a 5-digit number).
I want dd/mm/yyyy date format and I also tried to get the desired format by right-clicking one of the date field items in the pivot table and changing its format to dd/mm/yyyy but It did not update all the cells.
Why its happening and how to fix?