Forum Discussion
Imported dates not converting to correct format
LKO2022 When you do Text-to-columns, make sure that you choose the correct setting for the date column is step 3. Select Date and MDY as the source contains dates in the Month, Day, Year format. Now, Excel will import the dates correctly.
Alternatively, use Power Query (a.k.a. Get & Transform Data). Much more powerful than text-to-columns.
LKO2022 When you do Text-to-columns, make sure that you choose the correct setting for the date column is step 3. Select Date and MDY as the source contains dates in the Month, Day, Year format. Now, Excel will import the dates correctly.
Alternatively, use Power Query (a.k.a. Get & Transform Data). Much more powerful than text-to-columns.
Riny_van_Eekelen I am trying on query but I don't know how to fix. I am just newbie. Can help me with my case below?
jmustany That's difficult based on a picture alone. I suspect that the dates are in fact texts and that you need to transform to real dates using a 'Locale'.
Hi Riny_van_Eekelen,
I've got answered to my problem. I spot my error when do delimiter option. I shouldn't thick any of delimiter even though "." is the delimiter here. That's solved my problem. Thanks again!
- Thankyouthankyouthankyou! This little tip just saved me all kinds of hassle! Seemed like there should have been more letters, but it works.
- Works beautifully, thank you!!!
