incorrect import of text column

[Data_Scientist]

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 imported as an integer-field with the value 1.100. 

How can I avoid this without using the text import wizard ?

thanks

[#2]

Hi @Data_Scientist 

What method are you currently using to import the text file?

Are you using Power Query?

Hope that helps

Wyn

MVP

Australia UTC+ 8

[#3]

Hi @Wyn Hopkins 

This is a simple text-file , saved with extension .xls.

After saving, we can open the file without any actions and  all Field formats are ok at once.

so, we don't use the Power query to finish importing.

thks

[#4]

Hi @Data_Scientist 

My approach would be to leave the file as a .txt file then use  Power Query to import it and specify the column types in Power Query

Wyn

[#5]

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.