---
title: "Display Percentage Values Correctly"
url: "https://officeconnectpro.com/reference/troubleshoot/display-percentage-values/"
description: "How to prevent rounding from distorting percentage values in OfficeConnect.\n"
tags: ["reporting","fpna","system-admin","troubleshoot"]
date: "0001-01-01"
lastmod: "2026-05-19"
---


Percentages are a classic gotcha when Workday OfficeConnect's default Thousands rounding interacts with Adaptive Planning values stored as decimals. Before changing settings, review where rounding is configured in [Change Rounding Settings](/reference/troubleshoot/change-rounding-settings/) so you fix the right level.

**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)

{{< step n="1" title="Open Workbook Properties" >}}
In the OfficeConnect ribbon, click **Workbook Properties**.
{{< /step >}}

{{< step n="2" title="On the Format tab, set Round to No Rounding" >}}
{{< /step >}}

{{< step n="3" title="Format the percentage cells in Excel" >}}
Select the cells and use Excel's **Format Cells → Percentage** to display them correctly.
{{< /step >}}

{{< step n="4" title="Refresh" >}}
{{< /step >}}

**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

{{< step n="1" title="Select the cells that contain percentages" >}}
{{< /step >}}

{{< step n="2" title="In the OfficeConnect ribbon, open Row/Column/Cell Properties" >}}
Right-click → **OfficeConnect → Cell Properties** (or Row/Column Properties for a full row/column).
{{< /step >}}

{{< step n="3" title="Enable Suppress Rounding (Do Not Round Amounts)" >}}
{{< /step >}}

{{< step n="4" title="Format those cells as percentages using Excel" >}}
Select the cells → **Home tab → Number format → Percentage** (or use the `%` button).
{{< /step >}}

{{< step n="5" title="Refresh" >}}
{{< /step >}}

**Advantage:** The rest of the workbook keeps its rounding. Only the percentage cells display without rounding.

## Next steps

- [Change Rounding Settings](/reference/troubleshoot/change-rounding-settings/) to adjust workbook- or user-level rounding defaults
- [Workbook & Worksheet Properties](/wiki/build-reports/workbook-worksheet-properties/) for the rest of the format controls
- [Build a Budget vs. Actuals Variance Report](/wiki/build-reports/budget-vs-actuals-variance/) for a worked example mixing percentages and currency amounts