Display Percentage Values Correctly
How to prevent rounding from distorting percentage values in OfficeConnect.
Problem: Percentage values from Adaptive Planning appear as tiny decimals in OfficeConnect. For example, 25.25% shows as 0.0002525 when workbook rounding is set to Thousands.
This happens because OfficeConnect stores percentages as decimals (0.2525) and then applies the workbook’s rounding setting on top — Thousands rounding divides by 1,000, making it 0.0002525.
Fix option 1: Set rounding to No Rounding (whole workbook)
1
Open Workbook Properties
In the OfficeConnect ribbon, click Workbook Properties.
2
On the Format tab, set Round to No Rounding
3
Format the percentage cells in Excel
Select the cells and use Excel’s Format Cells → Percentage to display them correctly.
4
Refresh
Trade-off: This removes rounding from the entire workbook. All other numbers will display without rounding too.
Fix option 2: Suppress rounding on specific cells only
1
Select the cells that contain percentages
2
In the OfficeConnect ribbon, open Row/Column/Cell Properties
Right-click → OfficeConnect → Cell Properties (or Row/Column Properties for a full row/column).
3
Enable Suppress Rounding (Do Not Round Amounts)
4
Format those cells as percentages using Excel
Select the cells → Home tab → Number format → Percentage (or use the
% button).5
Refresh
Advantage: The rest of the workbook keeps its rounding. Only the percentage cells display without rounding.