How to Make a Weight Conversion in Excel

If you have Microsoft Excel, you don't need a separate unit conversion utility. Microsoft Excel includes a Convert function, which can convert between similar units of almost any type of measurement, including weight, length, mass, time, power and temperature. By constructing a weight conversion spreadsheet, you'll always have a weight converter handy without having to write out the formula each time you wish to convert a weight.

Instructions

1. Open Microsoft Excel.

2. Type "Weight," "Original Unit," "Convert to" and "Conversion" in cells A1 through A4.

3. Enter the numeric weight value in cell B1. As an example, to convert 150 lbs. into kilograms, enter "150."

4. Enter the original unit in cell B2. Accepted units of mass are "g" for gram, "kg" for kilogram, "lbm" for pounds and "ozm" for ounces. In the example, you would enter "lbm" in cell B2.

5. Enter the new unit in cell B3. In the example, you would enter "kg" in cell B3.

6. Enter "=CONVERT(B1,B2,B3)" in cell B4 to compute the converted weight.

References

• Microsoft Office: Convert Measurements
• Microsoft Office: Convert