How to stop Excel power query from rounding up numbers

[Edgar Saravia]

Hello.
I am trying to automate a CSV file through an Excel power query. The problem is that in the query editor, the numbers in the columns are rounding up to the nearest dollar (example below)
In the CSV files Values O/S | In Power query, I get this | Value O/S
0.54 1.00
How can I keep the query editor from round 0.54 to 1.00

Thanks.

 

[JEC]

Is that happening after the changed type step? If so, delete that step and format as decimal number instead

 

[Edgar Saravia]

Is that happening after the changed type step? If so, delete that step and format as decimal number instead

Thanks. Let me try it.