Forum Discussion
Excel changes custom format to a date when saving as a csv. File. How to get itnto stop?
Excel xlsx keeps converting a custom date, mm-dd-yyyy to the following format mm/dd/yyyy when saving as a csv file. How do I get it to stop, or how can I get this format added to the list of date form...
I was running into this same issue. We needed the date field to be mm/dd/yyyy and when saving as "CSV (Comma delimited) (*.csv)" the date field would go back to m/d/yyyy which is not an acceptable value for the system I was uploading it into (Cornerstone CSX). Well, it turns out that it might have been seeing it as a special character when Excel saved. I changed the file type option to "CSV UTF-8 (Comma delimited) (*.csv)" and the date remained in the format I needed and uploaded perfectly into the system I was needing it for. So, people on the thread if you haven't found a solution give that a try.
