Forum Discussion
CSV FILE CHANGING DATA - NUMBERS BEING CHANGED TO DATE FORMAT
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.
7 Replies
- Is the data already wrong after the import, or only when you save the data to a new CSV? If the latter, you should change the way you open the CSV file using the tips I wrote here: https://jkp-ads.com/articles/importtext.asp
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.
