Forum Discussion
CSV Dates sometimes changing format upon save
Hello, This is a stumper for me. I have two columns of type Date: ValidStartDate and ValidEndDate. Each one has the same respective date for each record: 1/1/2021 and 12/31/9999. After I save...
Yes definitely - what I am doing is constructing my file in Excel, then saving it as a CSV (see screenshot) and opening it in a completely different application (Notepad++).
I do this to ensure that the formatting is not occurring upon opening the file back up again in Excel, since I know it does a lot of formatting to CSV files upon opening, as you mentioned. This would be conditional formatting upon saving. The data before saving in Excel looks like the attached file.
Then I open in Notepad++ and the file looks like so:
Let me know if that still is not clear/you have additional questions.
Thank you for the assistance!
Alex
