Convert stones to kilograms in Excel and Google Sheets

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

A2 = data cell

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

Convert stones to kilograms in Excel

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

CONVERT STONES TO KILOGRAMS — EXCEL FORMULA AND EXAMPLE

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

  • A2 = data cell

Weight and mass units

  • Gram = "g"

  • Slug = "sg"

  • Pound mass (avoirdupois) = "lbm"

  • U (atomic mass unit) = "u"

  • Ounce mass (avoirdupois) = "ozm"

  • Grain = "grain"

  • U.S. (short) hundredweight = "cwt" or "shweight"

  • Imperial hundredweight = "uk_cwt" or "lcwt" ("hweight")

  • Stone = "stone"

  • Ton = "ton"

  • Imperial ton = "uk_ton" or "LTON" ("brton")

💡 Detailed measurement units definition outlined here

Convert stones to kilograms in Google Sheets

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

CONVERT STONES TO KILOGRAMS — GOOGLE SHEETS FORMULA AND EXAMPLE

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

  • A2 = data cell

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