This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Hi,
I have summed up a particular column and the the total in the cell is appearing to be rounded (2 decimals) but upon looking in the formula bar, there are multiple trailing zeros. All the other columns that have been summed are correct except this one. It also appears in my pivot, as well. Please advise how to remove the trailing zeros and only have it formatted to 2 decimal places?
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
It is fairly unpredictable for us mere mortals when the rounding errors will occur. It depends on a lot of factors.
It is fairly unpredictable for us mere mortals when the rounding errors will occur. It depends on a lot of factors.
Do you know what some common factors would be?
No. Perhaps jjoeu2004 will read this discussion, he is very knowledgeable on this topic.