Share via

How to remove trailing zeros in formula bar

Anonymous
2022-08-10T18:36:23+00:00

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?

Microsoft 365 and Office | Excel | For business | Windows

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.

0 comments

13 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2022-08-11T16:20:27+00:00

    Thanks for posting the data. Do any of the cells contain a formula? If so, which ones, and which formula?

    Yes, the second last row from the bottom (sum formula, essentially the first 768 in the dataset)

    0 comments
  2. HansV 462.4K Reputation points MVP Volunteer Moderator
    2022-08-11T16:28:19+00:00

    Thanks again. ROUND should work:

    0 comments
  3. Anonymous
    2022-08-11T17:02:00+00:00

    Thanks again. ROUND should work:

    Image

    Thank you for your assistance but do you know why it was stating 768.0000000000 in the first place?

    0 comments
  4. HansV 462.4K Reputation points MVP Volunteer Moderator
    2022-08-11T18:31:39+00:00
    0 comments
  5. Anonymous
    2022-08-11T19:03:12+00:00

    See Floating-point arithmetic may give inaccurate results in Excel

    Thank you for your assistance in this matter. This has never happened before, do you know why it could have occurred?

    0 comments