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'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!!!!
