Full Excel CONVERT Function Unit List: Every Supported Measurement Code
Excel’s CONVERT function supports codes for mass, distance, time, pressure, force, energy, power, magnetism, temperature, volume, area, information, and speed.
Excel’s CONVERT function accepts documented unit codes for 13 measurement groups, from mass and distance to information and speed. Enter the codes exactly as shown—capitalization matters—and convert only between units in the same group. The syntax is CONVERT(number,from_unit,to_unit): the value, its source unit, then its target unit.
How to use a CONVERT unit code
Put each unit code in quotation marks when supplying it as a text argument. For example, =CONVERT(1,"lbm","kg") converts one pound mass to kilograms and returns 0.4535924. The code lbm means pound mass; it is not the pound-force code lbf.
The lists below follow Microsoft’s documented CONVERT function reference. Where Microsoft gives alternatives, each listed spelling is accepted. Preserve case exactly, including in codes such as Nmi, Picapt, LTON, and Torr.
Weight and mass
Measurement
Unit code(s)
Gram
g
Slug
sg
Pound mass (avoirdupois)
lbm
Atomic mass unit
u
Ounce mass (avoirdupois)
ozm
Grain
grain
U.S. short hundredweight
cwt, shweight
Imperial hundredweight
uk_cwt, lcwt, hweight
Stone
stone
Ton
ton
Imperial ton
uk_ton, LTON, brton
Distance
Measurement
Unit code(s)
Meter
m
Statute mile
mi
Nautical mile
Nmi
Inch
in
Foot
ft
Yard
yd
Angstrom
ang
Ell
ell
Light-year
ly
Parsec
parsec, pc
Pica (1/72 inch)
Picapt, Pica
Pica (1/6 inch)
pica
U.S. survey mile
survey_mi
Time
Measurement
Unit code(s)
Year
yr
Day
day, d
Hour
hr
Minute
mn, min
Second
sec, s
Pressure
Measurement
Unit code(s)
Pascal
Pa, p
Atmosphere
atm, at
Millimeter of mercury
mmHg
PSI
psi
Torr
Torr
Force
Measurement
Unit code(s)
Newton
N
Dyne
dyn, dy
Pound-force
lbf
Energy
Measurement
Unit code(s)
Joule
J
Erg
e
Thermodynamic calorie
c
IT calorie
cal
Electron volt
eV, ev
Horsepower-hour
HPh, hh
Watt-hour
Wh, wh
Foot-pound
flb
BTU
BTU, btu
Power
Measurement
Unit code(s)
Horsepower
HP, h
Pferdestärke
PS
Watt
W, w
Magnetism
Measurement
Unit code(s)
Tesla
T
Gauss
ga
Temperature
Measurement
Unit code(s)
Celsius
C, cel
Fahrenheit
F, fah
Kelvin
K, kel
Rankine
Rank
Réaumur
Reau
Microsoft’s example =CONVERT(68,"F","C") returns 20.
The Microsoft Office 365 Bible: The Most Updated and Complete Guide to Excel, Word, PowerPoint, Outlook, OneNote, OneDrive, Teams, Access, and Publisher from Beginners to Advanced
ABIS BOOK
Volume and liquid measure
Measurement
Unit code(s)
Teaspoon
tsp
Modern teaspoon
tspm
Tablespoon
tbs
Fluid ounce
oz
Cup
cup
U.S. pint
pt, us_pt
U.K. pint
uk_pt
Quart
qt
Imperial quart
uk_qt
Gallon
gal
Imperial gallon
uk_gal
Liter
l, L, lt
Cubic angstrom
ang3, ang^3
U.S. oil barrel
barrel
U.S. bushel
bushel
Cubic feet
ft3, ft^3
Cubic inch
in3, in^3
Cubic light-year
ly3, ly^3
Cubic meter
m3, m^3
Cubic mile
mi3, mi^3
Cubic yard
yd3, yd^3
Cubic nautical mile
Nmi3, Nmi^3
Cubic pica
Picapt3, Picapt^3, Pica3, Pica^3
Gross registered ton
GRT, regton
Measurement ton/freight ton
MTON
Area
Measurement
Unit code(s)
International acre
uk_acre
U.S. survey/statute acre
us_acre
Square angstrom
ang2, ang^2
Are
ar
Square feet
ft2, ft^2
Hectare
ha
Square inches
in2, in^2
Square light-year
ly2, ly^2
Square meters
m2, m^2
Morgen
Morgen
Square miles
mi2, mi^2
Square nautical miles
Nmi2, Nmi^2
Square pica
Picapt2, Pica2, Pica^2, Picapt^2
Square yards
yd2, yd^2
Information
Measurement
Unit code(s)
Bit
bit
Byte
byte
Speed
Measurement
Unit code(s)
Admiralty knot
admkn
Knot
kn
Meters per hour
m/h, m/hr
Meters per second
m/s, m/sec
Miles per hour
mph
Prefixes for metric and binary units
Microsoft lists metric prefixes from yotta (Y, 1E+24) to yocto (y, 1E-24), and binary prefixes from yobi (Yi, 2^80) to kibi (ki, 2^10). Prefixes can be prepended to supported metric unit codes; this does not mean every unit accepts every prefix. In particular, using a binary prefix with a unit that does not support it returns #N/A. See Microsoft’s prefix and unit documentation for the documented prefix table.
Why CONVERT returns an error
#N/A: The unit code is unknown, the chosen unit does not support the binary prefix used, or the source and target units belong to different measurement groups.
#VALUE!: An argument has an incorrect data type.
For an area conversion, Microsoft’s example is =CONVERT(CONVERT(100,"ft","m"),"ft","m"), which returns 9.290304. It nests two length conversions to square the linear conversion factor; it is a specific example, not a general pattern for converting every area unit. For other area conversions, use the documented area codes as the source and target in the function.
Microsoft lists CONVERT for Excel for Microsoft 365, Excel 2024, Excel 2021, Excel 2019, and Excel 2016, including Mac editions where specified in its compatibility information.
Product prices and availability are accurate as of the date/time indicated and are subject to change. Any price and availability information displayed on Amazon at the time of purchase will apply.
