Convert pounds to kilograms in Excel and Google Sheets

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

A2 = data cell

Check below for a detailed explanation with pictures and how to use formulas in Excel and Google Sheets.

Convert pounds to kilograms in Excel

How to convert pounds to kilograms in Excel?
Convert pounds to kilograms in Excel

CONVERT POUNDS TO KILOGRAMS — EXCEL FORMULA AND EXAMPLE

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

  • A2 = data cell

  • To convert Kilograms to Pounds switch the unit position (kg & lbm) in the above formula

Available unit conversions by category

  • Weight – u, grain, g, ozm, lbm, stone, sg, cwt, uk_cwt, ton, uk_ton

  • Distance – ang, Picapt, pica, in, ft, yd, m, ell, mi, survey_mi Nmi, ly, parsec

  • Time – sec, min, hr, day, yr

  • Pressure – Pa, mmHg, Torr, psi, atm

  • Force – dyn, pond, N, lbf

  • Energy – eV, e, J, flb, c, cal, BTU, Wh, HPh

  • Power – W, PS, HP

  • Magnetism – ga, T

  • Temperature – C, F, K, Rank, Reau

  • Volume – ang^3, Picapt^3, tsp, tspm, tbs, in^3, oz, cup, pt, uk_pt, qt, l, uk_qt, gal, uk_gal, ft^3, bushel, barrel, yd^3, m^3, MTON, GRT, mi^3, Nmi^3, ly^3

  • Area – ang^2, Picapt^2, in^2, ft^2, yd^2, m^2,ar, Morgen,uk_acre, us_acre, ha, mi^2, Nmi^2, ly^2

  • Information – bit, byte

  • Speed – m/hr, mph, kn, admkn, m/s

💡 Detailed measurement units definition outlined here

Convert pounds to kilograms in Google Sheets

How to convert pounds to kilograms in Google Sheets?
Convert pounds to kilograms in Google Sheets

CONVERT POUNDS TO KILOGRAMS — GOOGLE SHEETS FORMULA AND EXAMPLE

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

  • A2 = data cell

  • To convert Kilograms to Pounds switch the unit position (kg & lbm) in the above formula

Available unit conversions by category

  • Weight – u, grain, g, ozm, lbm, stone, sg, cwt, uk_cwt, ton, uk_ton

  • Distance – ang, Picapt, pica, in, ft, yd, m, ell, mi, survey_mi Nmi, ly, parsec

  • Time – sec, min, hr, day, yr

  • Pressure – Pa, mmHg, Torr, psi, atm

  • Force – dyn, pond, N, lbf

  • Energy – eV, e, J, flb, c, cal, BTU, Wh, HPh

  • Power – W, PS, HP

  • Magnetism – ga, T

  • Temperature – C, F, K, Rank, Reau

  • Volume – ang^3, Picapt^3, tsp, tspm, tbs, in^3, oz, cup, pt, uk_pt, qt, l, uk_qt, gal, uk_gal, ft^3, bushel, barrel, yd^3, m^3, MTON, GRT, mi^3, Nmi^3, ly^3

  • Area – ang^2, Picapt^2, in^2, ft^2, yd^2, m^2,ar, Morgen,uk_acre, us_acre, ha, mi^2, Nmi^2, ly^2

  • Information – bit, byte

  • Speed – m/hr, mph, kn, admkn, m/s

💡 Detailed measurement units definition outlined here