I am working with a company that does a lot of conversions. For example, records are recorded in grams but compliance reports are recorded in tonnes.

By default, 1.5 grams, will show as 0.000002 tonnes. As such, all of my compliance reports are rounded before the final calculation.

Another use-case is GPS coordinates. I am working with geographical data that has 14 decimal places, but I am limited to 6 decimal places.

In formulas, I have to ROUND([Number],6) in order to even show a value. The default calculation just shows 0.

I am hoping this can be a quick and easy fix!