Max limit of decimal places in a value?

Kelly Moore
Kelly Moore ✭✭✭✭✭✭

I have a sheet where a cell needs to have a value greater than five decimal places. Using the increase/decrease decimal tool will not increase the decimal places past five places. Using ROUND function also will not increase the number of places.

I searched for documentation on decimal place limitations but was unable to find any restrictions. Is five the decimal limit?

My current sheet: 0.00005 My desired value: 0.000048

@Genevieve P @Genevieve P - this question might be one for you.



Best Answer