Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.
Last reviewed:
How to convert kilograms to pounds in Excel and Google Sheets
Topic:Unit conversionExcel & 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
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.
Working on a sheet you inherited? Run the Auditor on the whole file first — it flags every #REF!, #N/A, broken column pattern, and inconsistent formula in seconds, free, no signup.
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
See all →How-to
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-toHow 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-toHow 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-toHow 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-toHow 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-toHow to convert bytes to megabytes
Divide byte values by 1048576 (2^20) to convert bytes to megabytes in Excel or Google Sheets.