Forum Discussion
CSV FILE CHANGING DATA - NUMBERS BEING CHANGED TO DATE FORMAT
Format the column in which the codes are as text and don't just paste but paste special values into the template sheet. Perhaps that helps Excel not to convert information that resembles a date into a date.
JKPieterse - I am facing the issue where I want to add text values of the format 'MM/DD/YYYY' to be read as text. Certain values seem to be read as text automatically. Certain values are read as Date format 'MM-DD-YYYY' by default. I faced this issue specifically on csv. I had faced this issue on xlsx as well, but there I tried Data --> Text to Columns --> (next. next) --> Text, and it worked. The issue persists on csv.
And this peculiar issue does not recur on my colleague's excel csv file.
I am sharing the screenshot as well as sample csv file.
8/11/2019, 8/12/2019 get auto converted into 08-11-2019, 08-12-2019
8/13/2019, 8/14/2019 get saved as is. (General format) - This is what is expected.
- Can you please describe your *exact* steps one by one? It is unclear to me which steps you take exactly, and also what format your original documents are in (Excel file, other source?).
- text to col fixed the issue for me. Thanks
