Power Query

[gheyman]

Is there a way to make a column 4 decimals places without using Round? I dont want the number to round up or down.

 

[Peter_SSs]

I know your title says Power Query but is this any use?

=TRUNC(A1,4)

If not, perhaps you could expand a little on just what you have and what you are trying to achieve?

 

[Alex Blakenburg]

In Power Query selecting the Currency Data type will give you 4 decimals but it still has to convert the original figure somehow so internally it will still be rounding.

 

[gheyman]

I used "Extract" in a new column. "First Characters" = 6 I then changed the type back to decimal.

 

[RoryA]

You could also do something like:

Number.RoundTowardZero([value]*10000,0)/10000