Full CONVERT() measurement list for Excel

Office for Mere Mortals
Your beginners guide to the secrets of Microsoft Office
Invalid email address
Tips and help for Word, Excel, PowerPoint and Outlook from Microsoft Office experts.  Give it a try. You can unsubscribe at any time.  Office for Mere Mortals has been running for over 20 years, we've never, ever revealed or sold subscriber details.  Privacy policy

A full 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.

MeasureFormula Abbrev. (case sensitive)Inbuilt / Multiplier

Distance


Angstrom"ang"Inbuilt
Foot"ft"Inbuilt
Inch"in"Inbuilt
Meter"m"Inbuilt
Statute mile"mi"Inbuilt
Nautical mile"Nmi"Inbuilt
Pica"pica"Inbuilt
Yard"yd"Inbuilt
Kilometre"km"Multiplier
Millimetre"mm"Multiplier
Centimetre"cm"Multiplier

Weight / Mass


Gram"g"Inbuilt
Kilogram"kg"Multiplier
Milligram"mg"Multiplier
Pound mass (avoirdupois)"lbm"Inbuilt
Ounce mass (avoirdupois)"ozm"Inbuilt
Slug"sg"Inbuilt
U (atomic mass unit)"u"Inbuilt

Temperature


Degree Celsius"C" (or "cel")Inbuilt
Degree Fahrenheit"F" (or "fah")Inbuilt
Kelvin"K" (or "kel")Inbuilt

Time


Day"day"Inbuilt
Hour"hr"Inbuilt
Minute"mn"Inbuilt
Second"sec"Inbuilt
Year"yr"Inbuilt

Energy


BTU"BTU" (or "btu")Inbuilt
Foot-pound"flb"Inbuilt

Liquid Measure


Cup"cup"Inbuilt
Gallon"gal"Inbuilt
Liter"l" (or "lt")Inbuilt
Milliliter"ml"Multiplier
Fluid ounce"oz"Inbuilt
U.S. pint"pt" (or "us_pt")Inbuilt
Quart"qt"Inbuilt
Tablespoon"tbs"Inbuilt
Teaspoon"tsp"Inbuilt
U.K. pint"uk_pt"Inbuilt

Magnetism


Gauss"ga"Inbuilt
Tesla"T"Inbuilt

Power


Horsepower"HP" (or "h")Inbuilt
Watt"W" (or "w")Inbuilt

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"
subs profile e1563205311409 - Full CONVERT() measurement list for Excel
Latest news & secrets of Microsoft Office

Microsoft Office experts give you tips and help for Word, Excel, PowerPoint and Outlook.

Give it a try. You can unsubscribe at any time.  Office Watch has been running for over 20 years, we've never, ever revealed or sold subscriber details.  Privacy policy
Invalid email address