Convert kilograms to stones in Excel and Google Sheets

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

A2 = data cell

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

Convert kilograms to stones in Excel

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

CONVERT KILOGRAMS TO STONES β€” EXCEL FORMULA AND EXAMPLE

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

  • 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 kilograms to stones in Google Sheets

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

CONVERT KILOGRAMS TO STONES β€” GOOGLE SHEETS FORMULA AND EXAMPLE

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

  • 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