Excel CONVERT measurement list

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 - Excel CONVERT measurement list
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