How To It is possible to convert Measurements in Microsoft excel.
The function converts a measurement from one unit to another.Data and units will be entered into the formula to use this function.If you first learn how to enter the convert function manually or with the Formula builder, you will be able to apply that conversion to an entire column of data.Unit names are sensitive.
Step 1: The original unit should be labeled with column A.
For the purposes of this example, let's assume that the measurement you want to convert is in column A and you'd like to see the conversion results incolumn B, but really this method will work for any two columns.To label column A, click on cell A1 and type in the original unit you want converted.inches, meters, or yards.Click on cell A1 and type "Inches".In this example, we will convert 12 inches to feet.The unit you are converting the measurement to is called a to-unit.You can organize your data by labeling your columns.
Step 2: There is a column called B.
Click on cell B1.This will be your column.The measurement is being converted to a unit.This is also called a unit.Click on cell B1 and type in the amount.
Step 3: Your original measurement can be entered in cell A2.
The original measurement should be typed in numbers.Don't enter the units.In cell A2, enter 12 as in 12 inches.
Step 4: In cell B2, type the word convert.
Functions in excel are not sensitiveThe result is the same as typing "CONVERT()".
Step 5: The original measurement can be found in the name of the cell.
The "number" is what the convert function calls this value.It is possible to type an actual number in this spot when you are converting a single measurement.You would enter "Covert(12)" instead of "Convert(A2)."
Step 6: Add a sentence.
Your cell may now look like this.
Step 7: Enter in the unit.
Enter in the approved abbreviated form of the original unit.The "from_unit" is enclosed by a set of quotation marks.For example, "Convert(A2, "in"), or "Conversion(12, " in""ft" and "m" are approved unit abbreviations.Here, you can find a list of unit abbreviations.
Step 8: Enter the unit.
The approved abbreviation for the "to_unit" is enclosed by a set of quotation marks.For example, your cell should look like this.The contents of cell A2 will be converted from inches to feet by this example function.
Step 9: To execute the function, hit Enter.
In this case, cell B2, the converted measurement will appear.B2 will contain 1 as in 1 foot.Check the unit abbreviations again if the function returns an error.It is not possible to convert mass into length if the two units are in the same group.Unit names and prefixes are sensitive.This means you have entered the wrong number if the function returns the "#VALUE!" error.You need to only enter one value or cell reference.
Step 10: There is alabel column A.
If you want to see the conversion results in column B, you'll have to use this method, but it will work for any two columns.Click on cell A1 and type in the unit you want to convert.There are seconds, hours, or days.This is also called the from unit.In this example, we will convert 21 minutes to seconds.You can use the convert function to convert a measurement from one unit to another.You can organize your data by labeling your columns.
Step 11: There is a column called B.
Click on cell B1.This is your "to_unit" column.You can type in the unit you are converting the measurement to.There are seconds or days."Seconds" can be entered into cell B1.
Step 12: Your original measurement can be entered in cell A2.
The original measurement should be typed in numbers.Don't enter the units.In cell A2, enter the number 21.
Step 13: You can open theFormula Builder.
Instead of entering the function by hand, you can use the formula builder.There is a tab called the "Formula"Click on the box labeled "Formula Builder".Cell B2 should be selected.Make sure to select "CONVERT."
Step 14: The original measurement of the cell can be found in the "number" text box.
The "number" is what the convert function calls this value."A2" can be entered for example.You can type the actual measurement instead of the cell name for a single conversion.
Step 15: The original unit can be entered in the text box.
The original unit can be entered in the approved abbreviated form.The abbreviation for minutes is "mn"Here, you can find a list of unit abbreviations.
Step 16: The "to_unit" is entered.
The approved abbreviation is "to_unit."The abbreviation for seconds is "sec"
Step 17: To execute the function, press enter.
In this case, cell B2, the converted measurement will appear.You will see "1260" in cell B2 in 1260 seconds.Check the unit abbreviations again if you get a "#N/A" error.It is not possible to convert time into length if the two units are in the same group.Unit names and prefixes are sensitive.You may have entered the wrong number if you get a "#VALUE!" error.You need to only enter one value or cell reference.
Step 18: B2 is the location of your originalVERT function.
Let's assume that in addition to entering an original measurement in cell A2, you also filled cells A3 and A4 with a measurement.You have already converted the measurement in cell A2 to cell B2.If you drag the formula down into the cells in column B, you can quickly convert the rest of your measurements.For example, in cell A2, you entered 1; in cells A3 and A4 you enter 5 and 10, respectively.You entered a convert function in cell B2.The cell's name must be entered instead of the measurement in the "number" space.
Step 19: There is a gray square in the lower right corner.
There is a gray square in the lower right corner when you select a cell.
Step 20: To select multiple cells, drag your mouse down column B.
Only fill the cells in column B with the original measurements from column A.You will select cells B3 and B4 since you entered the measurements in cells A4 and A3.You can use the "fill" method to apply the convert function to multiple cells.Pick your cells from Column B after you've selected cell B2.Select all the cells that have the same measurement in column A.The converted measurements will appear in column B.
Step 21: Once you've selected all the cells you want to use the convert function to, release the cursor.
The measurement listed in column A will be converted to column B.For example, you will see 2.54 in cell B; 12.7 in cells B3 and B4; and 25.4.Check the unit abbreviations again if the function returns an error.It is not possible to convert mass into length if the two units are in the same group.Unit names and prefixes are sensitive.This means you have entered the wrong number if the function returns the "#VALUE!" error.You need to only enter one value or cell reference.