Hello, A variation on this question My array is mixing up the format of my dates, and I can't work out why
I have downloaded some data that contain in the same column 2 types of date format:
13-05-2022 05:49:58
and
12/5/2022 10:53:48 AM
Not sure why.
Formatting the whole column as date does not change the actual content of the cell. This seems to trip up any analysis with Pivot chart
Any suggestion to have a unique date format in the column?
Thanks
I have downloaded some data that contain in the same column 2 types of date format:
13-05-2022 05:49:58
and
12/5/2022 10:53:48 AM
Not sure why.
Formatting the whole column as date does not change the actual content of the cell. This seems to trip up any analysis with Pivot chart
Any suggestion to have a unique date format in the column?
Thanks