Forum Discussion
etaylor94
Jun 13, 2019Copper Contributor
Maintaining date format in CSV
I need to save a CSV file with a specific date format, but every time I try to save the file it keeps saying it's not an acceptable format, and then changes it to another format. I have tried telling...
ChrisMendoza
Jun 13, 2019Iron Contributor
Do you have a sample of your specific format?
In a quick test I ran, leading Zero's are removed; I added a single quote ( ' ) to convert the cell to Text but that just seems to work the same as using the Ribbon.
in the cell... '06/13/2019
mm/dd/yyyy essentially.