Forum Discussion

Data_Scientist's avatar
Data_Scientist
Copper Contributor
Apr 28, 2020

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...
excel
Wyn Hopkins's avatar
Wyn Hopkins
MVP
Apr 29, 2020

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

 

 

 

 

 

 

  • Data_Scientist's avatar
    Data_Scientist
    Copper Contributor
    Apr 29, 2020

    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

     

    • Wyn Hopkins's avatar
      Wyn Hopkins
      MVP
      Apr 30, 2020

      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

Resources