Get help with Microsoft Excel. You can find how-to articles, training videos, and support content. Manage appointments, plans, budgets — it's easy with Microsoft 365.
-->Note
Office 365 ProPlus is being renamed to Microsoft 365 Apps for enterprise. For more information about this change, read this blog post.
- Microsoft Excel is a spreadsheet developed by Microsoft for Windows, macOS, Android and iOS. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications (VBA).
- Learn more about how to get an Excel add-in. Offline viewing and authoring. Excel for the web is launched from an internet browser and relies on an internet connection. To access spreadsheets offline, Microsoft Excel desktop app must be installed on your computer and used to view and edit Excel worksheets.
- How to create a Pivot Table in Excel. Pivot Tables are considered by most advanced Excel users to.
Summary
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. For some purposes, this may not be a sufficient number of significant figures. This article explains how to display more digits in the coefficients.
Display more digits
The trendline equation and R-squared value are initially displayed as rounded to five digits. To display a greater number of digits, use one of the following methods:
Method 1: Microsoft Office Excel 2007
- Open the worksheet that contains the chart.
- Right-click the trendline equation or the R-squared text, and then click Format Trendline Label.
- Click Number.
- In the Category list, click Number, and then change the Decimal places setting to 30 or less.
- Click Close.
Buy Microsoft Excel
Method 2: Microsoft Office Excel 2003 and earlier versions of Excel
- Open the worksheet that contains the chart.
- Double-click the trendline equation or R-squared text.
- On the Number tab, click Number in the Category list, and then change the Decimal places setting to 30 or less.
- Click OK.
Note
What Is Microsoft Excel
Even though you can set the number of decimal places to 30 for the Number category, Excel only displays values to a maximum of 15 digits of precision. Additional digits are displayed as zero.
