Skip to main content
Adaptive Insights
Knowledge and Support - Adaptive Insights

OC: Rounding

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.

 

 
  • Was this article helpful?