OpenOfficeCalc - How to limit the number of decimal places?

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.
Published by jad05. Latest update on March 23, 2013 at 07:15 AM by deri58.
This document, titled "OpenOfficeCalc - How to limit the number of decimal places?," is available under the Creative Commons license. Any copy, reuse, or modification of the content should be sufficiently credited to CCM (
OpenOfficeCalc - Display formulas used instead of results
OpenOfficeCalc - Hide page breaks