Luckily, however, Excel is only rounding up the information that you see in the cell. This seems like the logical choice but, unfortunately, the default number formatting in Excel 2010 only includes two decimal places. When you, or whoever, created your spreadsheet, you may have set a row or column to use the Number formatting option, because you were going to be entering numbers into those cells. Like many of the more frustrating auto-correct errors that you will encounter in your Microsoft Excel career, this one is caused by improper formatting. How to Increase the Number of Decimal Places in Excel 2010 Unfortunately, this is not the case for every possible number that you might enter, and if you use numbers with a lot of decimal places, then Excel might very well be ignoring anything past the second place.īut you can display more decimal places in Excel 2010 by modifying the formatting settings of your cells, allowing you to store information in your desired format with the exactness that comes from using multiple decimal places.

Typically whatever you type into a cell will remain the same way that it was originally entered. If you are using Excel to store large amounts of data, then one of the reasons you are probably doing so is because you can trust Excel to accurately store that data. Can anyone figure out, what it is? Because I surely can't.Learning how to increase the number of decimal places in Excel 2010 is important for anyone that is working with spreadsheets where two decimal places is an insufficient level of detail.Įxcel often rounds numbers to that number of decimal places, which is a problem for the type of data where additional decimal place values are very important. I suppose Excel is working as it should, so it must be me doing something wrong. The only answer I have found is, that I should use more decimals, but I have tried to extend the number of decimals to 30, and it doesn't help. I have searched the internet for an explanation, but without succes. So there seems to something fundamentally wrong with the equation.

If I put three of the numbers above into this formula, the results are this:Ĩ0 => 35,048 (real result in table: 13,88)ġ00 => 31,658 (real result in table: 24,53)ġ20 => 24,748 (real result in table: 31,63)Īpart from being very different from the results in the table, the Y-values gets smaller in the Trend formula, while they get bigger in the input table. But when I choose Display equation on chart, it comes up with a Trend formula that has nothing to do with reality. When I enter the following data into Excel and generates af Forecast Analysis with a Polynomial Trendline (Order 2) Excel shows an almost perfect trendline in the diagram.

Excel trendline equation more decimals