Forum Discussion
CSV FILE CHANGING DATA - NUMBERS BEING CHANGED TO DATE FORMAT
The data is fine in the original documents, I select the column data required, copy and paste into the the csv template (not an actual template documents, just a .csv file I use with specific column order for importing into MYOB). The data looks fine, then I save and close. Its when I re-open the document it shows incorrectly. I am just confused as it is only one column that is effected and only half of the column. I read your article and will follow your steps next time I have to do the import.
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-20198/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?).
Will try this tip. Thank you for your help.
