What does it do?

Converts a number from one measurement system to another

Formula breakdown:

=CONVERT(number, from_unit, to_unit)

What it means:

=CONVERT(number, starting measurement system, target measurement system)


Did you know that Excel can convert numbers from one measurement system to another measurement system? Yes you can with the CONVERT Formula! You will be surprised at what units it can convert for you!

I explain how you can do this below:

DOWNLOAD EXCEL WORKBOOK

STEP 1: We need to enter the CONVERT function in a blank cell:

=CONVERT(

CONVERT Formula in Excel

 

STEP 2: The CONVERT arguments:

number

What is the numeric measurement?

Select the cell containing the number that you want to convert

=CONVERT(C9,

CONVERT Formula in Excel

from_unit

What is the starting measurement system?

Select the cell containing the starting measurement system.

=CONVERT(C9, D9,

CONVERT Formula in Excel

to_unit

What is the target measurement system?

Select the cell containing the target measurement system.

=CONVERT(C9, D9, E9)

CONVERT Formula in Excel

Apply the same formula to the rest of the cells by dragging the lower right corner downwards.

CONVERT Formula in Excel

You now have your conversions completed!

CONVERT Formula in Excel

 

Here is an extensive list of all of the units that you can use:

Category Unit Usage in CONVERT FORMULA
Weight and mass Gram “g”
Weight and mass Slug “sg”
Weight and mass Pound mass (avoirdupois) “lbm”
Weight and mass U (atomic mass unit) “u”
Weight and mass Ounce mass (avoirdupois) “ozm”
Weight and mass Grain “grain”
Weight and mass U.S. (short) hundredweight “cwt” or “shweight”
Weight and mass Imperial hundredweight “uk_cwt” or “lcwt” (“hweight”)
Weight and mass Stone “stone”
Weight and mass Ton “ton”
Weight and mass Imperial ton “uk_ton” or “LTON” (“brton”)
Distance Meter “m”
Distance Statute mile “mi”
Distance Nautical mile “Nmi”
Distance Inch “in”
Distance Foot “ft”
Distance Yard “yd”
Distance Angstrom “ang”
Distance Ell “ell”
Distance Light-year “ly”
Distance Parsec “parsec” or “pc”
Distance Pica (1/72 inch) “Picapt” or “Pica”
Distance Pica (1/6 inch) “pica”
Distance U.S survey mile (statute mile) “survey_mi”
Time Year “yr”
Time Day “day” or “d”
Time Hour “hr”
Time Minute “mn” or “min”
Time Second “sec” or “s”
Pressure Pascal “Pa” (or “p”)
Pressure Atmosphere “atm” (or “at”)
Pressure mm of Mercury “mmHg”
Pressure PSI “psi”
Pressure Torr “Torr”
Force Newton “N”
Force Dyne “dyn” (or “dy”)
Force Pound force “lbf”
Force Pond “pond”
Energy Joule “J”
Energy Erg “e”
Energy Thermodynamic calorie “c”
Energy IT calorie “cal”
Energy Electron volt “eV” (or “ev”)
Energy Horsepower-hour “HPh” (or “hh”)
Energy Watt-hour “Wh” (or “wh”)
Energy Foot-pound “flb”
Energy BTU “BTU” (or “btu”)
Power Horsepower “HP” (or “h”)
Power Pferdestärke “PS”
Power Watt “W” (or “w”)
Magnetism Tesla “T”
Magnetism Gauss “ga”
Temperature Degree Celsius “C” (or “cel”)
Temperature Degree Fahrenheit “F” (or “fah”)
Temperature Kelvin “K” (or “kel”)
Temperature Degrees Rankine “Rank”
Temperature Degrees Réaumur “Reau”
Volume Teaspoon “tsp”
Volume Modern teaspoon “tspm”
Volume Tablespoon “tbs”
Volume Fluid ounce “oz”
Volume Cup “cup”
Volume U.S. pint “pt” (or “us_pt”)
Volume U.K. pint “uk_pt”
Volume Quart “qt”
Volume Imperial quart (U.K.) “uk_qt”
Volume Gallon “gal”
Volume Imperial gallon (U.K.) “uk_gal”
Volume Liter “l” or “L” (“lt”)
Volume Cubic angstrom “ang3” or “ang^3”
Volume U.S. oil barrel “barrel”
Volume U.S. bushel “bushel”
Volume Cubic feet “ft3” or “ft^3”
Volume Cubic inch “in3” or “in^3”
Volume Cubic light-year “ly3” or “ly^3”
Volume Cubic meter “m3” or “m^3”
Volume Cubic Mile “mi3” or “mi^3”
Volume Cubic yard “yd3” or “yd^3”
Volume Cubic nautical mile “Nmi3” or “Nmi^3”
Volume Cubic Pica “Picapt3”, “Picapt^3”, “Pica3” or “Pica^3”
Volume Gross Registered Ton “GRT” (“regton”)
Volume Measurement ton (freight ton) “MTON”
Area International acre “uk_acre”
Area U.S. survey/statute acre “us_acre”
Area Square angstrom “ang2″ or “ang^2”
Area Are “ar”
Area Square feet “ft2” or “ft^2”
Area Hectare “ha”
Area Square inches “in2” or “in^2”
Area Square light-year “ly2” or “ly^2”
Area Square meters “m2” or “m^2”
Area Morgen “Morgen”
Area Square miles “mi2” or “mi^2”
Area Square nautical miles “Nmi2” or “Nmi^2”
Area Square Pica “Picapt2”, “Pica2”, “Pica^2” or “Picapt^2”
Area Square yards “yd2” or “yd^2”
Information Bit “bit”
Information Byte “byte”
Speed Admiralty knot “admkn”
Speed Knot “kn”
Speed Meters per hour “m/h” or “m/hr”
Speed Meters per second “m/s” or “m/sec”
Speed Miles per hour “mph”

 

The following abbreviated unit prefixes can be added in front of any metric from_unit or to_unit.

Prefix Multiplier Abbreviation
yotta 1.00E+24 “Y”
zetta 1.00E+21 “Z”
exa 1.00E+18 “E”
peta 1.00E+15 “P”
tera 1.00E+12 “T”
giga 1.00E+09 “G”
mega 1.00E+06 “M”
kilo 1.00E+03 “k”
hecto 1.00E+02 “h”
dekao 1.00E+01 “da” or “e”
deci 1.00E-01 “d”
centi 1.00E-02 “c”
milli 1.00E-03 “m”
micro 1.00E-06 “u”
nano 1.00E-09 “n”
pico 1.00E-12 “p”
femto 1.00E-15 “f”
atto 1.00E-18 “a”
zepto 1.00E-21 “z”
yocto 1.00E-24 “y”

 

How to Use the CONVERT Formula in Excel

HELPFUL RESOURCE:

 

 

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin