Excel like a finance pro.

The functions, VBA, and shortcuts a finance operator actually uses — curated, with CFO examples. Prefer them pre-built? Grab a ready-made model.

← The library

Engineering function

CONVERT

Converts a number between measurement units, like miles to kilometers.

OccasionalDifficulty 1200 · ProficientUsage rank #215 of 520

Practice · 3 questions →

When to use it

Converts a number between measurement units: distance, weight, temperature, volume, time, pressure, energy, speed, and more. Unit codes are case sensitive text.

The shape of it

Syntax: =CONVERT(number, from_unit, to_unit)
Example: =CONVERT(A1,"mi","km")

Worked examples

Distance
=CONVERT(1,"mi","km") → 1.609344
Miles to kilometers.
Temperature
=CONVERT(100,"F","C") → 37.77777778
Fahrenheit to Celsius.
Volume
=CONVERT(1,"gal","l") → 3.785411784
US gallons to liters.

Worth knowing

Metric prefixes attach to base units: "km", "mg", "GB".
Common codes: "lbm" pounds, "kg", "in", "ft", "m", "F", "C", "K", "hr", "mn", "sec", "day", "oz", "l", "gal", "psi", "Pa".
Both units must be in the same category or the result is #N/A.

Where it goes wrong

#N/A for unknown unit codes or a mismatch of categories.
Codes are case sensitive: "M" is not "m".

BIN2DEC DEC2BIN HEX2DEC DEC2HEX DELTA ERF

Learn the moves here — or let Wauvel run them on your numbers.

Meet your AI CFO →

One CFO-grade Excel tip a week

A short, practical email for finance operators — functions, shortcuts, and the moves that save an afternoon. Free, unsubscribe anytime.