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:

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

## =CONVERT(

STEP 2:Â The CONVERTÂ arguments:

## number

What is the numeric measurement?

Select the cell containing the number that you want to convert

## from_unit

What is the starting measurement system?

Select the cell containing the starting measurement system.

## to_unit

What is the target measurement system?

Select the cell containing the target measurement system.

## =CONVERT(C9, D9, E9)

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

See also  3 Simple Methods to Explore the Power of COUNTIF with OR Logic in Excel

You now have your conversions completed!

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