Numbers not showing as decimals when using Power Query

[danhendo888]

OneDrive

Sign in to your OneDrive cloud storage and Office Online.

1drv.ms

Trying to import this into Power Query, but the numbers in Column U to AB are appearing as whole numbers rather than including the decimals that can be seen if you click on the cell.

The steps that I have done:
Put file into folder
Open a From Folder query
Transform Data
Add Custom Column: Excel.Workbook([Content])
Expand the DATA
Then the numbers will show as rounded whole numbers

Not sure why this is happening. Any ideas how to show with decimals?

 

[alansidman]

When I change the format to decimals in native excel before importing to PQ, then they are shown as decimals. In native excel they are formatted as whole numbers.

 

[danhendo888]

Do you mean like this? 2021-03-16-09h57-33
Selecting the columns, CTRL+1, Number, 2 decimals?
Gave it a try, refreshed the Query, but doesn't seem to work.

Not a big deal though. I will keep trying