I came across a very strange behavior today. I have a csv file, with ID as a field. I copied the file to create a duplicate - called it File1. I opened File 1 in Excel, saved it as csv. If I then import it, the field type change to no format and 4971850000000 appears as 4.97185E+12 on import. If File2 is opened in notepad it display correctly. If I now compare the two file, I get incorrect information
Attached find a File 2 csv file. Duplicate it, open one file in excel and save as CVS. Import both into EM.
What can we do to prevent this?
File2…csv (615 Bytes)