CONVERT Function
Converts a measurement from one unit to another.
Category
Engineering
Available in
All versions, Microsoft 365
Returns
A number
Overview
CONVERT changes a value between units of the same kind — weight, distance, time, pressure, energy, power, temperature, volume, area, speed, information and more. Units are typed as short codes such as "kg", "mi" or "C".
Metric prefixes work too: "k" for kilo, "m" for milli, "c" for centi — so "km", "mm" and "cm" all work from "m". Binary prefixes such as "Gi" (gibi) apply to "byte" and "bit".
Syntax
Arguments
| Argument | Required? | What it does |
|---|---|---|
| number | Yes | The value to convert. |
| from_unit | Yes | The unit the number is in, as a code in quotes (case-sensitive). |
| to_unit | Yes | The unit you want. Must measure the same thing as from_unit. |
Examples
Example 1 — Shipping and logistics conversions
Northstar's suppliers quote in different units. Column B and C hold the unit codes. Results are rounded to 4 decimal places here.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Value | From | To | Result |
| 2 | 25 | kg | lbm | 55.1156 |
| 3 | 100 | km | mi | 62.1371 |
| 4 | 30 | C | F | 86 |
| 5 | 50 | l | gal | 13.2086 |
| 6 | 12 | in | cm | 30.48 |
Example 2 — Common unit codes
A quick reference. Codes are case-sensitive: "Pa" is pascal, "pa" isn't.
| A | B | |
|---|---|---|
| 1 | Kind | Codes |
| 2 | Weight | g, kg, lbm (pound), ozm (ounce), stone, ton |
| 3 | Distance | m, km, cm, mm, in, ft, yd, mi, Nmi |
| 4 | Time | sec (or s), mn (minute), hr, day, yr |
| 5 | Temperature | C, F, K |
| 6 | Volume | l, ml, gal, uk_gal, qt, pt, cup, tsp, tbs |
| 7 | Area | m2, ft2, ha, uk_acre (or us_acre) |
| 8 | Speed | m/s, km/h, mph, kn |
| 9 | Energy & power | J, cal, kWh, BTU · W, kW, HP |
| 10 | Information | bit, byte, kbyte, Mibyte, Gibyte |
Common mistakes
- #N/A A unit code is misspelled, uses the wrong case ("KG"), or the two units measure different things ("m" to "kg").
- Minutes are "mn", not "min". In CONVERT, "min" doesn't mean minutes. Use "mn" for minutes and "sec" for seconds.
Notes
- Temperature conversions handle the offsets for you: CONVERT(100,"C","F") is 212, not 180.
- Related functions: ROUND, TEXT.

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.