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.
The unit codes are wrong or from different families. Check the exact codes (e.g. "lbm" for pounds, "kg" for kilograms).
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.