Difficulty: Moderately Easy
Step1
Enter your data in a column of a spreadsheet. All measurements should have been taken in the same set of units. For example, for length measurements they should all be in inches.
Step2
Title the column of this list of measurements in units taken.
Step3
Title the next column as list of measurements in other set of units.
Step4
Move your cursor to the first cell in the second column.
Step5
Enter the conversion information. Type "=CONVERT(x, y, z)." The cell reference is placed in the "x" location. The units of measurement that your numbers in column 1 are in are placed in the "y" position. The units of measurements that you want to convert to is placed in the "z" position.
Step6
Find the exact way to enter the units in the formula in Step 5. These forms may be found by pulling up the help section within Excel. Look up CONVERT function.
Step7
Copy the formula that you entered in the first cell of the second column to all the cells of that column so that all your measurements are converted to the new units.