Forum Discussion
CSV Dates sometimes changing format upon save
Could you please clarify what do you mean here "when the file is saved as CSV and opened in a text editor" under text editor?
If you open csv file in Excel by double click it transform dates into the short format date at it is defined in your OS settings.
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
