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.
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.
Works beautifully, thank you!!!