Can You Stop a Cell From Rounding
Hi,
I am using cells simply to hold decimal numbers. What is the maximum number of decimal places you can go to and can you stop a cell from rounding the number?
Thanks
Steve
Best Answer

I believe it is 5 locations. If you aren't going to calculate on the result then you can use
=rounddown(2/3,5) to get the exact rounded value to the 5th location.
If you are going to calculate on the value and need it to exactly represent beyond 5 digits, the program visually rounds the number, but does not calculate off the rounded number. So if you leave it as you can still use it in calculations.
Answers

I believe it is 5 locations. If you aren't going to calculate on the result then you can use
=rounddown(2/3,5) to get the exact rounded value to the 5th location.
If you are going to calculate on the value and need it to exactly represent beyond 5 digits, the program visually rounds the number, but does not calculate off the rounded number. So if you leave it as you can still use it in calculations.

Help Article Resources
Categories
Check out the Formula Handbook template!