Forum Discussion
Solved
Imported dates not converting to correct format
I'm importing data from SAP to excel in csv file. Data has dates in MM/DD/YYYY format. When I take the data to excel and use 'Text to Columns' function, some of the dates are automatically converte...
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.
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!