Share via

Decimal Issues

Carlos Martin 1 Reputation point
2022-04-05T15:21:04.38+00:00

When the decimal is increased the value changes.190295-capture.png

Microsoft 365 and Office | Excel | For business | Windows

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Emi Zhang-MSFT 30,061 Reputation points Microsoft External Staff
    2022-04-06T06:17:06.967+00:00

    Hi @Carlos Martin ,
    Your problem may related to the floating-point arithmetic in Excel, I suggest you refer to this support article:

    https://learn.microsoft.com/en-us/office/troubleshoot/excel/floating-point-arithmetic-inaccurate-result

    As the article said:

    1. You can use the ROUND function to correct the result.
    2. You can go to File- Options- Advanced- When calculating this workbook- check the option “Set precision as displayed”

    Just checking in to see if the information was helpful. Please let us know if you would like further assistance.

    If the response is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.