I am using this following formula t

[rpal]

I am using this following formula to round the NEAREST thousand, It is rounding but it is giving '0' in the HUNDRED place, I want to remove '0' in the HUNDRED place. Is there any way I can remove '0'?.

Round({YourNumber},-3) will round to the NEAREST thousand.

If you want to always round up, try this:

Round({YourNumber}+499.9999999,-3)

 

[synapsevampire]

Why would you remove the 0 in the hundred place if you're rounding to 1000? WHat are you expecting in the 100 place?

Please provide an example of data and expected output.

-k

 

[rpal]

To round up to thousad I using Round function:

round({320645167},-3)

Result is :320645000
What I want to display is 320645 by removing '0' in HUNDRAD place. How can I do this.

--Rpal

 

[synapsevampire]

OK, I think that I understand now.

Try:

round(320645167,3)*.001

-k