Analyse-it
Analyse-it
  • Products
  • Pricing
  • Support
  • About us
Download trial Sign in
  • User's Guide
  • Preparing data for analysis

Setting the number format of a variable

Set the precision of the data so that the results of the analysis show to a suitable number of decimal places.

Note: If you do not set the number format (or you use the Excel General number format), the number of decimal places is determined by the data value with the most decimal places.
  1. Activate the dataset worksheet.
  2. On the Analyse-it ribbon tab, in the Dataset group, click Dataset.
    The dataset task pane opens.
  3. In the Variable list, select the variables:
    • To select a single variable, click the variable.
    • To select multiple variables, click the first variable then hold down the CTRL key and click each additional variable.
    • To select a range of variables, click the first variable then hold down the SHIFT key and click the last variable in the range.

    The cells of the selected variables highlight on the worksheet. You can also select cells on the worksheet to select the corresponding variables in the list.

  4. Click Number format.
  5. In the Format Cells window, click Number, set the number of Decimal places, and then click OK.
  6. Click OK.

    The data is re-formatted.

Related concepts
Presentation of numerical data

  •  What is Analyse-it?
  •  What's new?
  •  Administrator's Guide
  •  User's Guide
  •  Getting to know Analyse-it
  •  Preparing data for analysis
  •  Datasets
  •  Variables
  •  Measurement scales
  •  Missing values
  •  Case and frequency form data
  •  Setting the measurement scale of a variable
  •  Setting the minimum, maximum and units of a variable
  •  Ordering categorical data
  •  Setting the number format of a variable
  •  Labeling cases
  •  Assigning labels to categories
  •  Assigning colors/symbols to categories
  •  Transforming variables
  •  Transform functions
  •  Analyzing a subset of the data
  •  Working with analyses
  •  Feedback and crash reports
  •  Statistical Reference Guide



Version 6.15
Published 18-Apr-2023
Products
  • Standard Edition
  • Medical Edition
  • Quality Control & Improvement Edition
  • Method Validation Edition
  • Ultimate Edition
  • Compare Editions
  • Pricing
Support
  • Documentation
  • Tutorials
  • Download latest version
  • Release history
  • Contact support
Company
  • About us
  • Blog
  • Contact us
  • Privacy policy

Get Started

  • Download free trial
  • Sign In

© 2026 Analyse-it® Software, Ltd. All rights reserved.

Statistical analysis and method validation software for Microsoft Excel.

We use essential cookies to run the site, and optional analytics to improve the experience for visitors. For more information see our Privacy policy.