Forum Discussion
Data_Scientist
Apr 28, 2020Copper Contributor
incorrect import of text column
Hi, formerly the value '01.100' in a text-file was imported correctly & automatically in a xls-file with the same format ( 01.100 as text ) Since updates of MS 365 a few weeks ago, the value is...
Lewis-H
Apr 30, 2020Iron Contributor
To make the columns be imported successfully, you may need to replace the slash “\” with “,” and save the text file as a .csv file as a workaround. When importing it , select Comma.
Meanwhile, I also suggest you click on File>Feedback>Send a Frown to report the issue in From Text/CSV to our related team so that they will be aware of the issue for further investigation.
Meanwhile, I also suggest you click on File>Feedback>Send a Frown to report the issue in From Text/CSV to our related team so that they will be aware of the issue for further investigation.