Skip to main content
Documentation
Documentation
Adaptive Planning
Last Updated: 2023-06-23
Change Rounding Settings

Change Rounding Settings

This article includes suggestions and workarounds. Content may not be accurate for all use cases or represent best practices for the latest release.

Question

How do I change the rounding settings in OfficeConnect and do they apply to the entire workbook?

Answer

OfficeConnect allows you to apply universal rounding for the entire workbook and there is also selective rounding for columns and rows.
Universal Rounding
To update the rounding that is applied to an entire OC Excel workbook, please see the steps below.
  1. Login to OC for Excel and open up your workbook.
  2. Click on the OfficeConnect tab.
  3. Click on the
    Book Properties
     button in the top toolbar.
  4. Choose the
    Format
     tab.
  5. From the Round to drop-down select your preferred format (ex: millions).
  6. Click OK.
  7. Refresh the workbook.
Selective Rounding
If you would like to suppress the book rounding for specific columns or rows in the workbook, please see the steps below.
  1. Login to OC for Excel and open up your workbook.
  2. Highlight the entire row/column that you do not want the global rounding to apply to.
  3. Click on the OfficeConnect tab.
  4. Click on the
    Selection Properties
    button in the top toolbar.
  5. Check the Suppress Rounding (Do Not Round Amounts) box.
  6. Click OK.
  7. Refresh the workbook.