Round to multiples of 1000

[Tid14]

Hi in my Input the data contains the values

Input     

125400

35000

53000

62000

and I want ouput as 

1254

35

20

62

I have tried Round formula but it didnt showed up correctly.

[atcodedog05]

Hi @Tid14 

It seems like you are trying to trim right 0's

Here is how you can do it.

Workflow:

Hope this helps : )

[Luke_C]

Hi @Tid14 

Alternatively, you could divide by 1000: