Xtreme Pivot Tables
July 20, 2016
In the attachment is sample data that I am trying to change to date format. I have managed to change some of the dates in the Arrival column but not all of them. I have tried using local and splitting the time from the date but not successful. The file is downloaded from our sales database.
Thanks for your help
January 31, 2022
The "dates" in columns B:F are in fact texts and I note the dates are in the dd/mm/yyyy format. Provided that your system setting for dates is the same, you can easily transform them to real date/time values (i.e. numbers).
Select column B. On the Data ribbon, press "Text to columns". Change nothing and press Finish. Column B has now been transformed into date/time values. Repeat for the remaining date/time columns. Now, you can format the date/time to your liking.
Does this work for you?
Obviously, you can use PowerQuery for this as well, but that might be overkill.