Documentation

Analyse-it for Microsoft Excel v2.20 user-guide, providing step-by-step instructions on how to use and benefit from Analyse-it

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.