Forum

Change Dates from T...
 
Notifications
Clear all

Change Dates from Text to Date Format

3 Posts
2 Users
0 Reactions
185 Views
(@hutchdjr)
Posts: 17
Eminent Member
Topic starter
 

Good Day

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

 
Posted : 07/06/2022 1:43 am
Riny van Eekelen
(@riny)
Posts: 1195
Member Moderator
 

Hi David,

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.

 
Posted : 07/06/2022 2:33 am
(@hutchdjr)
Posts: 17
Eminent Member
Topic starter
 

Hi Riny

Thanks very much so simple I feel stupid. It work perfectly and thanks for the tip.

 
Posted : 07/06/2022 6:43 am
Share: