FormulaCraft

CONVERT

CONVERT translates a numeric value between measurement units using standardised unit code strings (e.g. "mi" to "km", "lbm" to "kg"). It supports a wide range of categories including distance, weight, temperature, pressure, energy, and speed, eliminating the need for manual conversion constants.

Excel
=CONVERT(26.2,"mi","km")
Google Sheets
=CONVERT(26.2,"mi","km")

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

How it works

  1. 1Enter the numeric value you want to convert, the from-unit code (e.g. "mi" for miles), and the to-unit code (e.g. "km").
  2. 2Use =CONVERT(number, from_unit, to_unit) — all unit codes are case-sensitive strings.
  3. 3Refer to Excel or Sheets documentation for the full list of supported unit code strings across categories.

Need a version for your data?

Try: “Convert 26.2 miles to kilometres for a marathon distance.”

Related

DEC2BINDEC2HEXBIN2DEC

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

Last reviewed: