Forum Discussion
jckeddy
Jan 27, 2020Copper Contributor
Date Formatting Issues when copying for a cvs workbook
Does anyone know how to fix a formatting issue when copying from a cvs excel workbook? When I try to copy from a cvs workbook to a xlsx workbook on a Mac in Office 365 the date formatting doesn'...
jckeddy
Jan 28, 2020Copper Contributor
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.
Riny_van_Eekelen
Jan 28, 2020Platinum Contributor
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.