Forum Discussion
How to remove decimal places permanently
Hi all, I am new to the community. A Google search for a solution to my problem landed me here! Thanks. I have a worksheet where various values are displayed as follows: 14369.1666666667 ...
Hello SergeiBaklan,
Thanks a lot. As the system gives some warning that the accuracy of the data would be lost, I am now scared to use. How serious is that issue?
BR
How serious it depends on concrete data.
For example, for $100/3 result will be $33.33 (instead of $33.33333333333...) if you set precision on 2 digits. Multiplying back $33.33 x 3 = $99.99. Other words you lost one cent from $100 on such simple operations.