Forum Discussion
Date Formatting Issues when copying for a cvs workbook
jckeddy That's because when you copy from a csv, you are copying text. Excel does not know that that the text string "Saturday, January 11, 2020 ......" is a date. Get rid of "Saturday, " to begin with and tell Excel the "January 11, 2020" is a date based on MDY (= month-day-year). You can use DATA - Text to columns to do this. The pictures below demonstrate the process.
Riny_van_Eekelen Thanks for the info however, when I followed your pictures it ended up putting each part of the date and time in separate columns. See Pic bellow.
It looks like you did this:
Make it like this (i.e remove the automatic column separators except the one shown below):
Then you should get two columns. Make sure that the date becomes "Date: MDY" and leave the time as "General".
Then it should create two columns in your sheet. To combine Date and time, do like what's in the picture below. Now you have a Date/Time that you can format to your liking.