How to convert kilograms to pounds in Excel and Google Sheets

Topic:Unit conversion

Excel & Google Sheets

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

Try it with your data

Edit the grid or formula, then run it through a real spreadsheet engine — no signup.

Sample data — click any cell to edit

Cell row 1 column 1	Cell row 1 column 2
Cell row 2 column 1	Cell row 2 column 2
Cell row 3 column 1	Cell row 3 column 2
Cell row 4 column 1	Cell row 4 column 2

Formula

Runs server-side · free · no signup

Step by step

1Enter kilogram values in column B.
2In column C, enter =CONVERT(B2,"kg","lbm") to convert to pounds.
3Or use =B2*2.20462 as a direct multiplication alternative.
4Copy the formula down for all rows and format to 2 decimal places.

Tips

Use ROUND(CONVERT(B2,"kg","lbm"),2) to limit the result to two decimal places, which is typical for weight displays.

Need it for your exact data?

Describe your columns in plain English and get the precise formula for your sheet, with the right Excel or Sheets syntax.

Frequently asked

Why does CONVERT use 'lbm' instead of 'lb'?

'lbm' stands for pound-mass, the standard unit identifier in the CONVERT function. Both Excel and Sheets recognise it.

How do I convert pounds back to kilograms?

Swap the arguments: =CONVERT(B2,"lbm","kg") or use =B2/2.20462.

More on Unit conversion

How to convert minutes to hours

Turn a number of minutes into decimal hours by dividing by 60. The same simple formula in Excel and Google Sheets.

How to convert inches to centimeters

Multiply the inch value by 2.54 or use the CONVERT function to change inches to centimeters in Excel or Google Sheets.

How to convert Celsius to Fahrenheit

Multiply Celsius by 9/5 and add 32, or use the CONVERT function, to change temperatures in Excel or Google Sheets.

How to convert miles to kilometers

Multiply miles by 1.60934 or use CONVERT with 'mi' and 'km' units to change miles to kilometers in Excel or Sheets.

How to convert feet to meters

Multiply feet by 0.3048 or use CONVERT with 'ft' and 'm' to change feet to meters in Excel or Google Sheets.

How to convert bytes to megabytes

Divide byte values by 1048576 (2^20) to convert bytes to megabytes in Excel or Google Sheets.

Formulas used

CONVERT ROUND / ROUNDUP / ROUNDDOWN PRODUCT

Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.

Last reviewed: May 28, 2026