Home

CSV FILE CHANGING DATA - NUMBERS BEING CHANGED TO DATE FORMAT

louchar
New Contributor

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:-

DATEAC CODESHOULD BE 
1/31/20196-17026-1702

CORRECT FORMAT

1/31/20196-17046-1704CORRECT FORMAT
1/31/20196-17056-1705CORRECT FORMAT
1/31/2019Jun-006-1900CHANGED
1/31/2019Jun-006-2000CHANGED
1/31/2019Jun-016-2101CHANGED

 

Any incite would be greatly appreciated.

 

4 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.

Will try this tip.  Thank you for your help.

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Edge insider Dev bypasses IE mode website list
HotCakeX in Enterprise on
4 Replies