Analyse-it examines the number format applied to the worksheet cells to infer the precision (number of decimal places) of the observations. If no number format, or the Excel General format, is applied Analyse-it will scan the observations and automatically determine the number of decimal places used. Statistics for the variable are then presented based on the precision of the observations (see Presentation precision).
Number formats can be applied to Excel cells as usual, though Analyse-it provides a convenient way to quickly format all the observations of a variable.
To set the number of decimal places:
To apply a custom Excel format to a variable: