How to Convert Lbs to Kg in Excel (3 Easy Methods)

Excel is used all over the world to organize data and perform financial analysis. It works better than a calculator and it’s easy to use. While working with a dataset you might need to convert values to a different unit. Excel does have some built-in features to do it. You can convert pound values to kilogram values easily. In this article, I will show you how you can convert lbs to kg in Excel.

How to Convert Lbs to Kg in Excel: 3 Methods

Today I will describe 3 simple methods to convert pounds (lbs) to kilograms (kg) in Excel.

Suppose we have a dataset of some Patient Names and their Weight in pound units.

1. Use CONVERT Function to Convert Lbs to Kg in Excel

There are different ways to convert values to a specific unit. The CONVERT function in Excel converts a numeric value from one measurement unit to another measurement unit. You can call this CONVERT function a pocket calculator for converting units.

Steps:

Select a cell to write the formula. Here I have selected cell (E5).
Put the formula down-

=CONVERT(D5,"lbm","kg")

Press Enter and drag down the “fill handle” to get the output in all cells.

Here you will see we have all our pound (lbs) values converted into kilogram (kg) by using formulas.

Read More: How to Convert Kg to Lbs in Excel

2. Divide or Multiply with a Factor to Convert Lbs to Kg in Excel

To convert lbs to kg there are some basic conversion amounts. The formula for converting stand-to

1 pound (lb) = 0.453592 kilograms (kgs)

1 kilogram (kg) = 2.20462 pound (lbs)

In this method, I am going to divide the pound (lb) values by 2.205 to convert them into kilogram (kg) units.

Step 1:

Choose a cell. Here I have chosen cell (E5) to apply the formula.
Put the formula down-

=D5/2.205

Hit the Enter
Pull the “fill handle” down to fill the series.

Thus we will get our conversion values in all the cells in a different column.

You can also multiply the pound (lb) units by 0.45359237 to get your desired kilogram (kg) unit. Follow the steps-

Step 2:

Select a cell (E5) to write the formula.
Apply the following formula in the selected cell-

=D5*0.45359237

Press the Enter button to get the result.
Now drag down the “fill handle” to fill all the cells from the column.

Well, we have successfully converted pound units to kilogram units just by multiplying with a numeric value.

Read More: Converting CM to Inches in Excel

3. Run a VBA Code to Convert Lbs to Kg in Excel

You can also convert units with VBA code. In this method, I will share with you the VBA code to convert pound units into kilogram units.

Steps:

Open the “Microsoft Visual Basic for Applications” by pressing Alt+F11.

Click the “Module” from the “Insert” section.

Apply the following code to the module-

Sub LbstokgConverter()
Dim Lbstokg As Long
Lbstokg = InputBox("How much weight in pounds(lbs)?")
MsgBox "Weight is=" & Lbstokg * 0.45359237 & "kg."
End Sub

Press “Run”.

An “Inputbox” will appear asking for the pound (lb) value.
Put a data of your wish. Here I have put 100.
Click OK.

As you can see the “Input” box will show the converted value in a new “Msgbox”. Thus you can get your precious result.

Read More: How to Convert MM to CM in Excel

Things to Remember

You might find some changes in the converted value with a little fraction. Don’t worry. It’s just a little bit of ups and downs because of the decimal values.

Download Practice Workbook

Convert Lbs to Kg.xlsm

Conclusion

In this article, I have tried to cover all the simple methods to convert lbs to kg in Excel. Take a tour of the practice workbook and download the file to practice by yourself. Hope you find it useful. Please inform us in the comment section about your experience. We, the Exceldemy team, are always responsive to your queries. Stay tuned and keep learning.

<< Go Back to Excel CONVERT Function | Excel Functions | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!