The Excel CONVERT function converts a number from one measurement unit to another — distance, weight, temperature, time, energy, pressure, and dozens more.
Syntax
| Argument | Description | |
|---|---|---|
number | Required | The value to convert. |
from_unit | Required | The source unit code, e.g. "mi", "kg", "C", "hr". |
to_unit | Required | The target unit code, e.g. "km", "lbm", "F", "sec". |
How to use it
CONVERT converts a number from one measurement unit to another — distance, weight, temperature, time, energy, pressure, and dozens more. It uses short unit codes — "mi" miles, "km" kilometers, "kg" kilograms, "lbm" pounds, "C"/"F"/"K" temperatures, "hr"/"mn"/"sec" time, and many more. Units must be from compatible categories (you can’t convert mass to distance).
Metric prefixes work too: add k, c, m, etc. to a base unit (“km”, “cm”). CONVERT returns #N/A for unknown units and #N/A for incompatible categories — check Microsoft’s unit-code table for the exact strings.
Try it: interactive demo
Adjust the inputs and watch the formula and result.
Practice workbook
Frequently asked questions
What does CONVERT return?
Which Excel versions support it?
How do I find the right unit codes?
Why #N/A from CONVERT?
Master functions like this in one day
This page covers one function. Our Excel Formulas and Functions class covers the 30 that matter most — live, hands-on, taught by professionals in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.
See the Formulas & Functions Class