2. First learn how to enter the convert function manually or with Excel's Formula builder then discover how to apply that conversion to an entire column of data. Last Updated: March 29, 2019 Here the daily entry table, you enter only your weight and that is all. In this example, we will convert 21 (number) minutes (from_unit) to seconds (to_unit). b. This gives you the result 378.54: =CONVERT (100,"gal", "l") Notice the conversion codes for each unit of measure. 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). Functions & Formulas. Make sure you have only entered one value or cell reference. Please note, unit names and prefixes ARE case-sensitive. This tutorial will demonstrate how to convert values given in pounds to kilograms (or kilograms to pounds) in Excel & Google Sheets. {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/2\/2b\/Convert-Measurements-Easily-in-Microsoft-Excel-Step-1-Version-4.jpg\/v4-460px-Convert-Measurements-Easily-in-Microsoft-Excel-Step-1-Version-4.jpg","bigUrl":"\/images\/thumb\/2\/2b\/Convert-Measurements-Easily-in-Microsoft-Excel-Step-1-Version-4.jpg\/aid31735-v4-728px-Convert-Measurements-Easily-in-Microsoft-Excel-Step-1-Version-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/7\/76\/Convert-Measurements-Easily-in-Microsoft-Excel-Step-2-Version-3.jpg\/v4-460px-Convert-Measurements-Easily-in-Microsoft-Excel-Step-2-Version-3.jpg","bigUrl":"\/images\/thumb\/7\/76\/Convert-Measurements-Easily-in-Microsoft-Excel-Step-2-Version-3.jpg\/aid31735-v4-728px-Convert-Measurements-Easily-in-Microsoft-Excel-Step-2-Version-3.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/a\/af\/Convert-Measurements-Easily-in-Microsoft-Excel-Step-3-Version-4.jpg\/v4-460px-Convert-Measurements-Easily-in-Microsoft-Excel-Step-3-Version-4.jpg","bigUrl":"\/images\/thumb\/a\/af\/Convert-Measurements-Easily-in-Microsoft-Excel-Step-3-Version-4.jpg\/aid31735-v4-728px-Convert-Measurements-Easily-in-Microsoft-Excel-Step-3-Version-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/7\/74\/Convert-Measurements-Easily-in-Microsoft-Excel-Step-4-Version-4.jpg\/v4-460px-Convert-Measurements-Easily-in-Microsoft-Excel-Step-4-Version-4.jpg","bigUrl":"\/images\/thumb\/7\/74\/Convert-Measurements-Easily-in-Microsoft-Excel-Step-4-Version-4.jpg\/aid31735-v4-728px-Convert-Measurements-Easily-in-Microsoft-Excel-Step-4-Version-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/f\/f4\/Convert-Measurements-Easily-in-Microsoft-Excel-Step-5-Version-2.jpg\/v4-460px-Convert-Measurements-Easily-in-Microsoft-Excel-Step-5-Version-2.jpg","bigUrl":"\/images\/thumb\/f\/f4\/Convert-Measurements-Easily-in-Microsoft-Excel-Step-5-Version-2.jpg\/aid31735-v4-728px-Convert-Measurements-Easily-in-Microsoft-Excel-Step-5-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/1\/1e\/Convert-Measurements-Easily-in-Microsoft-Excel-Step-6-Version-2.jpg\/v4-460px-Convert-Measurements-Easily-in-Microsoft-Excel-Step-6-Version-2.jpg","bigUrl":"\/images\/thumb\/1\/1e\/Convert-Measurements-Easily-in-Microsoft-Excel-Step-6-Version-2.jpg\/aid31735-v4-728px-Convert-Measurements-Easily-in-Microsoft-Excel-Step-6-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/5\/50\/Convert-Measurements-Easily-in-Microsoft-Excel-Step-7-Version-2.jpg\/v4-460px-Convert-Measurements-Easily-in-Microsoft-Excel-Step-7-Version-2.jpg","bigUrl":"\/images\/thumb\/5\/50\/Convert-Measurements-Easily-in-Microsoft-Excel-Step-7-Version-2.jpg\/aid31735-v4-728px-Convert-Measurements-Easily-in-Microsoft-Excel-Step-7-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/6\/61\/Convert-Measurements-Easily-in-Microsoft-Excel-Step-8-Version-2.jpg\/v4-460px-Convert-Measurements-Easily-in-Microsoft-Excel-Step-8-Version-2.jpg","bigUrl":"\/images\/thumb\/6\/61\/Convert-Measurements-Easily-in-Microsoft-Excel-Step-8-Version-2.jpg\/aid31735-v4-728px-Convert-Measurements-Easily-in-Microsoft-Excel-Step-8-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/d\/dd\/Convert-Measurements-Easily-in-Microsoft-Excel-Step-9-Version-2.jpg\/v4-460px-Convert-Measurements-Easily-in-Microsoft-Excel-Step-9-Version-2.jpg","bigUrl":"\/images\/thumb\/d\/dd\/Convert-Measurements-Easily-in-Microsoft-Excel-Step-9-Version-2.jpg\/aid31735-v4-728px-Convert-Measurements-Easily-in-Microsoft-Excel-Step-9-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, Entering a Convert Function with Formula Builder, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/2\/26\/Convert-Measurements-Easily-in-Microsoft-Excel-Step-10-Version-2.jpg\/v4-460px-Convert-Measurements-Easily-in-Microsoft-Excel-Step-10-Version-2.jpg","bigUrl":"\/images\/thumb\/2\/26\/Convert-Measurements-Easily-in-Microsoft-Excel-Step-10-Version-2.jpg\/aid31735-v4-728px-Convert-Measurements-Easily-in-Microsoft-Excel-Step-10-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/8\/89\/Convert-Measurements-Easily-in-Microsoft-Excel-Step-11-Version-2.jpg\/v4-460px-Convert-Measurements-Easily-in-Microsoft-Excel-Step-11-Version-2.jpg","bigUrl":"\/images\/thumb\/8\/89\/Convert-Measurements-Easily-in-Microsoft-Excel-Step-11-Version-2.jpg\/aid31735-v4-728px-Convert-Measurements-Easily-in-Microsoft-Excel-Step-11-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/f\/f1\/Convert-Measurements-Easily-in-Microsoft-Excel-Step-12-Version-2.jpg\/v4-460px-Convert-Measurements-Easily-in-Microsoft-Excel-Step-12-Version-2.jpg","bigUrl":"\/images\/thumb\/f\/f1\/Convert-Measurements-Easily-in-Microsoft-Excel-Step-12-Version-2.jpg\/aid31735-v4-728px-Convert-Measurements-Easily-in-Microsoft-Excel-Step-12-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/1\/16\/Convert-Measurements-Easily-in-Microsoft-Excel-Step-13-Version-2.jpg\/v4-460px-Convert-Measurements-Easily-in-Microsoft-Excel-Step-13-Version-2.jpg","bigUrl":"\/images\/thumb\/1\/16\/Convert-Measurements-Easily-in-Microsoft-Excel-Step-13-Version-2.jpg\/aid31735-v4-728px-Convert-Measurements-Easily-in-Microsoft-Excel-Step-13-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/6\/65\/Convert-Measurements-Easily-in-Microsoft-Excel-Step-14-Version-2.jpg\/v4-460px-Convert-Measurements-Easily-in-Microsoft-Excel-Step-14-Version-2.jpg","bigUrl":"\/images\/thumb\/6\/65\/Convert-Measurements-Easily-in-Microsoft-Excel-Step-14-Version-2.jpg\/aid31735-v4-728px-Convert-Measurements-Easily-in-Microsoft-Excel-Step-14-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/5\/5e\/Convert-Measurements-Easily-in-Microsoft-Excel-Step-15-Version-2.jpg\/v4-460px-Convert-Measurements-Easily-in-Microsoft-Excel-Step-15-Version-2.jpg","bigUrl":"\/images\/thumb\/5\/5e\/Convert-Measurements-Easily-in-Microsoft-Excel-Step-15-Version-2.jpg\/aid31735-v4-728px-Convert-Measurements-Easily-in-Microsoft-Excel-Step-15-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/5\/5e\/Convert-Measurements-Easily-in-Microsoft-Excel-Step-16-Version-2.jpg\/v4-460px-Convert-Measurements-Easily-in-Microsoft-Excel-Step-16-Version-2.jpg","bigUrl":"\/images\/thumb\/5\/5e\/Convert-Measurements-Easily-in-Microsoft-Excel-Step-16-Version-2.jpg\/aid31735-v4-728px-Convert-Measurements-Easily-in-Microsoft-Excel-Step-16-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/6\/64\/Convert-Measurements-Easily-in-Microsoft-Excel-Step-17-Version-2.jpg\/v4-460px-Convert-Measurements-Easily-in-Microsoft-Excel-Step-17-Version-2.jpg","bigUrl":"\/images\/thumb\/6\/64\/Convert-Measurements-Easily-in-Microsoft-Excel-Step-17-Version-2.jpg\/aid31735-v4-728px-Convert-Measurements-Easily-in-Microsoft-Excel-Step-17-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, Applying the Convert Function to Multiple Cells, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/f\/fc\/Convert-Measurements-Easily-in-Microsoft-Excel-Step-18-Version-2.jpg\/v4-460px-Convert-Measurements-Easily-in-Microsoft-Excel-Step-18-Version-2.jpg","bigUrl":"\/images\/thumb\/f\/fc\/Convert-Measurements-Easily-in-Microsoft-Excel-Step-18-Version-2.jpg\/aid31735-v4-728px-Convert-Measurements-Easily-in-Microsoft-Excel-Step-18-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/f\/f9\/Convert-Measurements-Easily-in-Microsoft-Excel-Step-19-Version-2.jpg\/v4-460px-Convert-Measurements-Easily-in-Microsoft-Excel-Step-19-Version-2.jpg","bigUrl":"\/images\/thumb\/f\/f9\/Convert-Measurements-Easily-in-Microsoft-Excel-Step-19-Version-2.jpg\/aid31735-v4-728px-Convert-Measurements-Easily-in-Microsoft-Excel-Step-19-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/5\/5e\/Convert-Measurements-Easily-in-Microsoft-Excel-Step-20-Version-2.jpg\/v4-460px-Convert-Measurements-Easily-in-Microsoft-Excel-Step-20-Version-2.jpg","bigUrl":"\/images\/thumb\/5\/5e\/Convert-Measurements-Easily-in-Microsoft-Excel-Step-20-Version-2.jpg\/aid31735-v4-728px-Convert-Measurements-Easily-in-Microsoft-Excel-Step-20-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/6\/6e\/Convert-Measurements-Easily-in-Microsoft-Excel-Step-21-Version-2.jpg\/v4-460px-Convert-Measurements-Easily-in-Microsoft-Excel-Step-21-Version-2.jpg","bigUrl":"\/images\/thumb\/6\/6e\/Convert-Measurements-Easily-in-Microsoft-Excel-Step-21-Version-2.jpg\/aid31735-v4-728px-Convert-Measurements-Easily-in-Microsoft-Excel-Step-21-Version-2.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"

License: Fair Use<\/a> (screenshot)
\n<\/p><\/div>"}, How to Convert Measurements Easily in Microsoft Excel, comprehensive list of unit abbreviations here. Weight Converter. The entry tables are in Kilograms or Lbs. Please note, unit names and prefixes ARE case-sensitive. All conversions are exact, with the possible exception of conversions between foot-pounds and other units, which is accurate to at least 15 significant digits. Once you have received the verification code, you will be able to choose a new password for your account. You can use the following formula to convert 100 gallons into liters. Popular Articles: In one of the previous articles, we discussed three essential functions for calculating average in Excel, which are very straightforward and easy-to-use.But what if some of the values have more "weight" than others and consequently … For example: enter “Seconds” into cell B1. The standard BMI formula is: BMI = weight (kg) / height (m)2 The approach used here is to first convert height in inches and feet to meters, and weight in pounds to kilograms, then use the standard metric formula for BMI. Kutools for Excel: Weight Metric Conversion Chart Templates. Then click Ok or Apply, and you can see the converting results are shown in comments. We still want mean = 0 and standard deviation =1, so change NORMSINV(x) to NORM.INV(x,0,1). Place the cursor in the first empty box under column C, which is "Weight (kgs)", and enter the following: =B2/2.2. Use convert function to convert the measurements for distance, weight, time, temperature etc from one format to another Excel Podcast. This new blood sugar chart was created based on feedback from multiple users and doctors. After you've selected cell B2, hold down. m (lb) = m (kg) / 0.45359237. You can already DOWNLOAD the weight loss chart. The Microsoft Excel CONVERT function will convert a number from one measurement unit to another measurement unit. Select a blank cell next to your pounds data, and type this formula =CONVERT(A2,"lbm","ozm") into it, and press Enter key, then drag the autofill handle down to the range cells you need. Select which conversion approach you wish to use: a. The formulas below use the CONVERT function to convert yards to meters, Celsius to Fahrenheit, gallons to liters, and square meters to square yards: Popular Articles: I will show you in this free tutorial... SEARCH. For example, Convert can translate a table of distances in miles to a table of distances in kilometers.