Excel Worksheet keeps calculating to about 8 decimal places

Posted on 2012-09-04
Last Modified: 2012-09-04
I have a spread sheet which keeps calculating to loads of decimal places even though I have told it to only do this to two places.  I can see two places but when it adds it together it rounds up or down as if it is calculating to more places.

Any ideas?

Question by:Simonrepro
    LVL 44

    Expert Comment

    by:Martin Liss
    Can you attach the spreadsheet?
    LVL 43

    Expert Comment

    by:Saqib Husain, Syed
    The internal calculations will always be to 15 digits. What you probably have told it is to DISPLAY the numbers to 2 decimal places.

    To do rounded calculations you will have to use the round function with your formulas


    Author Comment

    I don't want it to round, I want it to add together a load of numbers which are to two decimal places and give me the result as a two decimal places result.  That should not need rounding.
    LVL 44

    Expert Comment

    by:Martin Liss
    Again, if you could attach your worksheet it would help us help you, but try something like

    MyResult = Format(MyResult, "0.00")
    LVL 1

    Accepted Solution

    Have you tried copying all your spreadsheet info to a new Excel spreadsheet? I've seen instances where formulas don't work the way they're supposed to and I copy & paste everything to a new workbook and it does the trick... just a thought.

    Author Closing Comment

    That worked thanks!

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    A2 = A1 That kind of cell reference is relative.  If you copy it from A2 to B2, then B2 will get this: B2 = B1 That's all fine and good, but if you then insert a new row above row 2, you'll find: A3 = A1 B3 = B1 This is intentional. …
    This article will guide you to convert a grid from a picture into Excel format using Microsoft OneNote and no other 3rd party application.
    This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
    This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

    760 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now