OpenOfficeCalc - How to limit the number of decimal places?

October 2016

To configure these settings under OpenOffice Calc:
  • Click on Tools > Options > Calc > Calculate.
  • In the right pane, check "Limit decimals for general number formats".
  • Edit the value next to "Decimal places":
  • Click on OK to validate.

Related :

This document entitled « OpenOfficeCalc - How to limit the number of decimal places? » from CCM ( is made available under the Creative Commons license. You can copy, modify copies of this page, under the conditions stipulated by the license, as this note appears clearly.