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
number: The amount to convert.from_unit: The unit the number is in, in quotes and spelled exactly, such as "mi", "lbm" or "F".to_unit: The unit to convert to, such as "km", "kg" or "C".
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
Miles to kilometres
A B C 1 Miles 2 10 16.09 In C2:
=CONVERT(A2, "mi", "km")→ 16.09Fahrenheit to Celsius
A B C 1 °F 2 68 20 In C2:
=CONVERT(A2, "F", "C")→ 20Pounds to kilograms
A B C 1 Pounds 2 150 68.04 In C2:
=CONVERT(A2, "lbm", "kg")→ 68.04The pound as a weight is "lbm".
Minutes to hours
A B C 1 Minutes 2 90 1.5 In C2:
=CONVERT(A2, "mn", "hr")→ 1.5A minute is "mn"; "m" is a metre.
Common mistakes
- Capitals matter. "mi" is a mile, and "Mi" is nothing. A unit Excel does not know gives #N/A.
- Units of different kinds. A length cannot become a weight: CONVERT(1, "m", "kg") is #N/A.
- Abbreviations that are not what you expect. Pounds are "lbm", ounces "ozm", minutes "mn", seconds "sec", litres "l" and US gallons "gal".
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.
- Czech: CONVERT
- Danish: KONVERTER
- Dutch: CONVERTEREN
- Finnish: MUUNNA
- French: CONVERT
- German: UMWANDELN
- Hungarian: KONVERTÁLÁS
- Italian: CONVERTI
- Norwegian: KONVERTER
- Polish: KONWERTUJ
- Portuguese (Brazil): CONVERTER
- Portuguese (Portugal): CONVERTER
- Russian: ПРЕОБР
- Spanish: CONVERTIR
- Swedish: KONVERTERA
- Turkish: ÇEVİR