Minitab®  Support

Example of recoding individual values

Learn more about Minitab

An engineer copies a column of numbers to a worksheet, and wants to recode the value -999 to the symbol *, which denotes a missing value.

  1. In the column name cell, type Data.
  2. Copy and paste, or type the following data into the Data column:
    91
    92
    77
    -999
    95
    69
    78
    85
    -999
    88
  3. Choose Data > Recode > To Numeric.
  4. In Recode values in the following columns, enter Data.
  5. From Method, select Recode individual values.
  6. In the Recoded value column, change -999 to *.
  7. Click OK.

Results

The recoded values are in a new column of the worksheet.

C1 C2
Data Recoded Data
91 91
92 92
77 77
-999 *
95 95
69 69
78 78
85 85
-999 *
88 88
Copyright © 2025 Minitab, LLC. All rights Reserved.