Feb 06 2019 04:45 PM
Please help,
I need to produce a csv file to import data into MYOB. After I import the data required and save the csv file, when I re-open it, the account codes are being changed to a date format - the first 15 lines are correct then from line 16 to the end, the below formatting occurs. How can I keep the original data:-
DATE | AC CODE | SHOULD BE | |
1/31/2019 | 6-1702 | 6-1702 | CORRECT FORMAT |
1/31/2019 | 6-1704 | 6-1704 | CORRECT FORMAT |
1/31/2019 | 6-1705 | 6-1705 | CORRECT FORMAT |
1/31/2019 | Jun-00 | 6-1900 | CHANGED |
1/31/2019 | Jun-00 | 6-2000 | CHANGED |
1/31/2019 | Jun-01 | 6-2101 | CHANGED |
Any incite would be greatly appreciated.
Feb 07 2019 01:37 AM
Feb 07 2019 02:28 PM
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.
Feb 07 2019 10:15 PM
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.
Feb 10 2019 03:08 PM
Will try this tip. Thank you for your help.
Jan 29 2020 04:22 AM
@Jan Karel Pieterse - 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.
Jan 30 2020 02:04 AM
Aug 02 2021 07:13 PM