For example: click on cell A1 and type “Inches”. In this example, we will convert 12 (number) inches (from_unit) to feet (to_unit). Excel’s convert function converts a “from unit,” into a “to-unit” (the unit you are converting the measurement to). Labeling your columns will help you organize your data.
For example: click on cell B1 and type “Feet”. [1] X Research source
For example: in cell A2, enter “12” (as in 12 inches). [2] X Research source
Functions in Excel are not case-sensitive. Typing “=CONVERT(” has the same result as typing “=convert(”.
For example: “=Convert(A2” When you are converting a single measurement, as in the example above, It is also possible to type an actual number (not a cell reference) in this spot. Instead of “=Convert(A2”, you would enter “=Covert(12”.
For example, your cell may now look like this: “=Convert(A2,” or “=Convert(12,”.
For example: “=Convert(A2, “in”,” or “=Convert(12, “in”,”. Some approved unit abbreviations are “in” “cm” “ft” and “m”. Excel provides a comprehensive list of unit abbreviations here.
For example, your cell should look something like: “=Convert(A2, “in”, “ft”)” or “=Convert(12, “in”, “ft”)”. This example function will convert the contents of cell A2 from inches to feet.
For example: B2 will contain “1” (as in 1 foot). [3] X Research source If the function returns the “#N/A” error, check the unit abbreviations again. Make sure the abbreviation is correct and that the two units belong to the same group (for example it is not possible to convert mass into length). Please note, unit names and prefixes ARE case-sensitive. If the function returns the “#VALUE!” error, this means you have entered the “number” incorrectly. Make sure you have only entered one value or cell reference. [4] X Research source
For example: type “Minutes” into cell A1. In this example, we will convert 21 (number) minutes (from_unit) to seconds (to_unit). Excel’s convert function converts a measurement from its original unit, or “from unit,” into a “to-unit” (the unit you’re converting the measurement to). Labeling your columns will help you organize your data.
For example: enter “Seconds” into cell B1. [5] X Research source
For example: in cell A2, enter “21” (as in 21 minutes). [6] X Research source
Select the “Formula” tab. Click “Formula Builder”. Select cell B2. Select “CONVERT. ”
For example: enter “A2”. For a single conversion, as in this example, you may also type the actual measurement (“21”) instead of the cell name.
For example: type “mn” (the abbreviation for minutes). Excel provides a comprehensive list of unit abbreviations here.
For example: type “sec” (the abbreviation for seconds).
For example: in cell B2, you will see “1260” (as in 1260 seconds). [7] X Research source If you receive a “#N/A” error, check the unit abbreviations again. Make sure the abbreviation is correct and that the two units belong to the same group (for example, it is not possible to convert time into length). Please note, unit names and prefixes ARE case-sensitive. If you get a “#VALUE!” error, you may have entered the “number” incorrectly. Make sure you have only entered one value or cell reference. [8] X Research source
For example: in cell A2, you entered “1”; in cell A3, you entered “5”; in cell A4, you entered “10”. The convert function you entered in cell B2 reads: “=Convert(A2, “in”, “cm”)”. When you are converting multiple measurements, you must enter the cell’s name instead of your measurement in the “number” space.
For example: since you entered measurements in cells A3 and A4, you will select cells B3 and B4. Alternately, you may apply the convert function to multiple cells using the “fill” method. After you’ve selected cell B2, hold down ⇧ Shift and select your cells from Column B. You should select all the cells that have corresponding measurements in column A. Click the “Home” tab. Select “Fill” then select and “Down. ” The converted measurements will appear in column B.
For example: you will see “2. 54” in cell B2; “12. 7” in cell B3; and “25. 4” in cell B4. [9] X Research source If the function returns the “#N/A” error, check the unit abbreviations again. Make sure the abbreviation is correct and that the two units belong to the same group (for example it is not possible to convert mass into length). Please note, unit names and prefixes ARE case-sensitive. If the function returns the “#VALUE!” error, this means you have entered the “number” incorrectly. Make sure you have only entered one value or cell reference. [10] X Research source
