Skip to content

Full CONVERT() measurement list for Excel

A full and searchable list of the measurements and multiplier prefixes available for Excel’s CONVERT function.

This is a table of the abbreviations used in the Excel CONVERT() function. The basic units inbuilt to the function are all listed plus some of the common measures available using the Multiplier prefixes.

Below that are a list of all the multiplier prefixes used by CONVERT() from common ones like ‘k’ for ‘km’ kilometer and ‘kg’ kilogram’ to less well-known ‘atto’ and ‘exa’.

Measurements for Convert()

MeasureFormula Abbrev. (case sensitive)Inbuilt / MultiplierType
Angstrom"ang"InbuiltLength / Distance
Foot"ft"InbuiltLength / Distance
Inch"in"InbuiltLength / Distance
Meter"m"InbuiltLength / Distance
Statute mile"mi"InbuiltLength / Distance
Nautical mile"Nmi"InbuiltLength / Distance
Pica"pica"InbuiltLength / Distance
Yard"yd"InbuiltLength / Distance
Kilometre"km"MultiplierLength / Distance
Millimetre"mm"MultiplierLength / Distance
Centimetre"cm"MultiplierLength / Distance
Gram"g"InbuiltWeight/Mass
Kilogram"kg"MultiplierWeight/Mass
Milligram"mg"MultiplierWeight/Mass
Pound mass (avoirdupois)"lbm"InbuiltWeight/Mass
Ounce mass (avoirdupois)"ozm"InbuiltWeight/Mass
Slug"sg"InbuiltWeight/Mass
U (atomic mass unit)"u"InbuiltWeight/Mass
Degree Celsius"C" (or "cel")InbuiltTemperature
Degree Fahrenheit"F" (or "fah")InbuiltTemperature
Kelvin"K" (or "kel")InbuiltTemperature
Day"day"InbuiltTime
Hour"hr"InbuiltTime
Minute"mn"InbuiltTime
Second"sec"InbuiltTime
Year"yr"InbuiltTime
BTU"BTU" (or "btu")InbuiltEnergy
Foot-pound"flb"InbuiltEnergy
Cup"cup"InbuiltLiquid Measure
Gallon"gal"InbuiltLiquid Measure
Liter"l" (or "lt")InbuiltLiquid Measure
Milliliter"ml"MultiplierLiquid Measure
Fluid ounce"oz"InbuiltLiquid Measure
U.S. pint"pt" (or "us_pt")InbuiltLiquid Measure
Quart"qt"InbuiltLiquid Measure
Tablespoon"tbs"InbuiltLiquid Measure
Teaspoon"tsp"InbuiltLiquid Measure
U.K. pint"uk_pt"InbuiltLiquid Measure
Gauss"ga"InbuiltMagnetism
Tesla"T"InbuiltMagnetism
Horsepower"HP" (or "h")InbuiltPower
Watt"W" (or "w")InbuiltPower

Multipliers

Prefix these to some abbreviations to make other measurement units. For example ‘k’ for kilo plus ‘g’ for gram = ‘kg’ for kilogram.  The more commonly used ones are in bold.

exa1.00E+18"E"
peta1.00E+15"P"
tera1.00E+12"T"
giga1.00E+09"G"
mega1.00E+06"M"
kilo1.00E+03"k"
hecto1.00E+02"h"
dekao1.00E+01"e"
deci1.00E-01"d"
centi1.00E-02"c"
milli1.00E-03"m"
micro1.00E-06"u"
nano1.00E-09"n"
pico1.00E-12"p"
femto1.00E-15"f"
atto1.00E-18"a"

About this author

Office-Watch.com

Office Watch is the independent source of Microsoft Office news, tips and help since 1996. Don't miss our famous free newsletter.