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...
HansVogelaar The problem is a conversion problem from Excel to CSV, not the other way around! When converting a Text formatted Excel file to CSV, the date changes form a custom date of mm-dd-yyyy to mm/dd/yyyy which fails to upload in a governmental program that requires mm-dd-yyyy. It is my belief, along with many others using this governmental program that Excel does not have a standard mm-dd-yyyy date format, so, even though it is formatted as text, the conversion changes the file as what it recognizes as a date.
I'm afraid I cannot reproduce the problem.
But a possible workaround is to use formulas in another column of the form
=TEXT(..., "mm-dd-yyyy")
Since that is a text value, it should be saved without change in the csv file.
- Haha that is exactly what I can't have!!!!! It must be mm-dd-yyyy. It is required to be this format, no other!!!!