When working with large numbers, you often need to round them. If you need to round to thousands, please check here. If you need to round to millions, please use the ROUND Function.
=ROUND(A2,-6)
When one hundred thousand's digit is 5 or above, the result rounds up, when one hundred thousand's digit is less than 5, the result rounds down.
If you need to round up all the numbers even when the one hundred thousand's digit is less than 5, you will need to use the ROUNDUP function.
=ROUNDUP(A2,-6)
If you need to round down all the numbers even when the one hundred thousand's digit is 5 or larger, you will need to use the ROUNDDOWN function.
=ROUNDDOWN(A2,-6)
