On the Number tab, click Number in the Category list, and then change the Decimal places setting to 30 or less.In the Decimal places box, enter the number of decimal places that you want to display. In the Category list, depending on the type of data you have, click Currency, Accounting, Percentage, or Scientific. Double-click the trendline equation or R-squared text. On the Home tab, in the Number group, click the arrow next to the list of number formats, and then click More Number Formats.Method 2: Microsoft Office Excel 2003 and earlier versions of Excel In the Category list, click Number, and then change the Decimal places setting to 30 or less.Right-click the trendline equation or the R-squared text, and then click Format Trendline Label.Round Function: Rounds results of the slope and intercept functions 2 two decimal places in this example because otherwise, the formula produces a large number of decimal places. Open the worksheet that contains the chart. Intercept Function: Provides the y-intercept for the equation and has the same structure as slope.To display a greater number of digits, use one of the following methods: Method 1: Microsoft Office Excel 2007 The trendline equation and R-squared value are initially displayed as rounded to five digits. Double click on the equation and ctrl c to copy, click on the cell and ctrl v to paste. This article explains how to display more digits in the coefficients. Right click on the trendline equation, Format Trendline Label, change Category to Number and add 10 decimals. For some purposes, this may not be a sufficient number of significant figures. When you add a trendline to a chart, and then display the equation and R-squared value for the trendline, the equation shows only the first five digits of each coefficient.

Excel trendline equation decimal places