Excel Power Query: Force import decimal data as Text

Question

I am importing data from an excel table into Excel power query. The excel table has decimal data but formatted as Text. When I import this table into Excel Power Query, it reads the decimal data and adds more digits to its end. For instance, the number 1.1 in excel is converted to 1.1000000000000001. Note that not all the numbers are imported in that form. For instance, the number 2.1 is imported as it is.

Moreover, when I convert this column type to decimal number in the Power Query editor the numbers appear to be in the correct form. However, I want this column type to be Text not Decimal so I can Merge this query with another query with the correct number form.

Please refer to the following screenshots:

The data in Excel Table:

The data in Power Query Editor:

In Power Query when changing the data type to decimal:

Answer 1

select that column and try to use text to column function and select Text in the step 3 to transfer the data type to text.

Then import to power query to see if the data display correctly or not.