Data Changes when pulled into Power Query

[lmcauthen00]

I have a data set that I import into Power Query, and it changes the data.

Example, a number that should be 162.50 (and reads the correct amount in my data table) pull into PQ as 162. My formatting on my original sheet is correct. Anyone have any recommendations on how to stop this?

 

[sandy666]

maybe change column format to decimals?
---
upper left corner of the column - format selection - Decimal Number

 

[lmcauthen00]

I've done that!

 

[lmcauthen00]

Its odd because I have 36 columns, Jan 2016-Dec 2018, and it only changes starting at Nov 2017. This is just in PQ not my data table.

 

[sandy666]

Its odd because I have 36 columns, Jan 2016-Dec 2018, and it only changes starting at Nov 2017. This is just in PQ not my data table.

be more descriptive
---
on the right side (Query settings) remove Changed Type then set proper format for each column

for more:
Microsoft Power Query for Excel Help