Convert between units — miles to km, lbs to kg, F to C, and more.
Copy this formula
=CONVERT(A2, "mi", "km")CONVERT(number, from_unit, to_unit) handles distance, weight, temperature, volume, time, and more using standard unit codes. The from and to units must belong to the same measurement family.
=CONVERT(100, "F", "C")→37.78100°F is about 37.78°C.
=CONVERT(10, "km", "mi")→6.2110 kilometers is about 6.21 miles.
=CONVERT(70, "kg", "lbm")→154.3270 kilograms is about 154.32 pounds.
The unit codes are wrong or from different families. Check the exact codes (e.g. "lbm" for pounds, "kg" for kilograms).
Yes. "mi" works but "MI" returns #N/A, so type the codes exactly as listed.
Use the squared and cubed codes, such as "m2" and "ft2" for area: =CONVERT(50, "m2", "ft2").
No. CONVERT only covers physical units such as length, weight, temperature and time. Multiply by an exchange rate instead.
Need a formula for your own data?
Describe what you want in plain language and let ExcelGPT write, explain, and verify the formula — free to start, no plugin.