How to Convert Measurements in Excel
For complex spreadsheets where many calculations must be performed, unit conversions may need to be done before they can be used. If you have measurements that were taken in one unit, you can change the units of that measurement into the units needed by using the CONVERT function.
Other People Are Reading
Instructions
-
-
1
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.
-
2
Title the column of this list of measurements in units taken.
-
-
3
Title the next column as list of measurements in other set of units.
-
4
Move your cursor to the first cell in the second column.
-
5
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.
-
6
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.
-
7
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.
-
1
Tips & Warnings
It is always a good practice to do the first conversion by hand on paper and compare it to the answer reported by the formula that you entered on the first measurement.
