Excel functions / Math

CONVERT function

Converts a number from one unit of measurement to another: miles to kilometres, pounds to kilograms, Fahrenheit to Celsius.

Syntax

=CONVERT(number, from_unit, to_unit)

Arguments

When to use it

CONVERT changes a number from one unit of measurement to another: miles to kilometres, pounds to kilograms, Fahrenheit to Celsius, hours to minutes.

Both units are written in quotes and spelled exactly as Excel spells them, capitals included. Metric units take prefixes, so "km", "mg" and "kWh" all work.

Examples

  1. Miles to kilometres

    ABC
    1Miles
    21016.09

    In C2: =CONVERT(A2, "mi", "km") → 16.09

    Try this example

  2. Fahrenheit to Celsius

    ABC
    1°F
    26820

    In C2: =CONVERT(A2, "F", "C") → 20

    Try this example

  3. Pounds to kilograms

    ABC
    1Pounds
    215068.04

    In C2: =CONVERT(A2, "lbm", "kg") → 68.04

    The pound as a weight is "lbm".

    Try this example

  4. Minutes to hours

    ABC
    1Minutes
    2901.5

    In C2: =CONVERT(A2, "mn", "hr") → 1.5

    A minute is "mn"; "m" is a metre.

    Try this example

Common mistakes

Common questions

How do I convert kg to lbs in Excel?

Use =CONVERT(A2, "kg", "lbm"), where A2 holds the weight in kilograms. For the other direction, swap the two units.

How do I convert Celsius to Fahrenheit in Excel?

Use =CONVERT(A2, "C", "F"). Temperatures are the one conversion that is not a simple multiplication, and CONVERT handles the offset for you.

CONVERT in other languages

Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.

Translate a whole formula

Try CONVERT in the playground

Related functions