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

Excel Management
Excel Management
Excel: A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.Management: The act or process of organizing, handling, directing or controlling something.
1,669 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Emi Zhang-MSFT 23,031 Reputation points Microsoft Vendor
    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.