This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Currently we are importing data and then changing the date and time using a custom format to mm/dd/yyyy hh:mm:ss and then saving as a .CSV . When we reopen the file the time has left off the seconds, this has just started happening in the last week before this it worked fine. Do you have a fix or has anyone experienced this issue as of late?
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Comments have been turned off. Learn more
This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
Comments have been turned off. Learn more
As I wrote. So your problem is NOT that the seconds are left off. It is that you are not SEEING them.
Why can't you format the cells to show the seconds?
When we open as a text file it shows correctly, but when we open the csv file which defaults to Excel they do not show, but if you select the cell you will see the correct format.
How did you reopen the file? If you opened it in Excel, you need to realize that CSV files do not retain formatting codes; so if your default format does not include seconds, you'll probably need to account for that.
In addition, if your Windows REgional settings default short date format is not also MDY, you may get really messed up.