You are viewing part of the Analyse-it for Microsoft Excel user-guide. When you have read this topic we recommend you view contents of the user-guide or you can read more about Analyse-it, our statistical analysis software for Microsoft Excel.

---

Open topic with navigation

Changing the presentation decimal places

Although Analyse-it presents statistics only to a suitable precision (see About presentation precision), internally the Excel cells contain the statistics calculated to 15 significant figures (see Calculation precision).

To change the number of decimal places a statistic is shown to:

1. Select the cell containing the statistic .
2. Click on the Home tab/Standard toolbar to increase, or to decrease, the number of decimal places shown.

NOTE Changes to cell formatting will be lost when the report is updated.

Part of the Analyse-it for Microsoft Excel user guide. For more information about Analyse-it, the statistics add-in for Microsoft Excel, or to download a free 30-day trial please visit http://www.analyse-it.com/. © Analyse-it Software, Ltd. Analyse-it® is a registered trademark. Microsoft® Excel® is a registered trademark of Microsoft.