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:

CategoryUnitUsage in CONVERT FORMULA
Weight and massGram“g”
Weight and massSlug“sg”
Weight and massPound mass (avoirdupois)“lbm”
Weight and massU (atomic mass unit)“u”
Weight and massOunce mass (avoirdupois)“ozm”
Weight and massGrain“grain”
Weight and massU.S. (short) hundredweight“cwt” or “shweight”
Weight and massImperial hundredweight“uk_cwt” or “lcwt” (“hweight”)
Weight and massStone“stone”
Weight and massTon“ton”
Weight and massImperial ton“uk_ton” or “LTON” (“brton”)
DistanceMeter“m”
DistanceStatute mile“mi”
DistanceNautical mile“Nmi”
DistanceInch“in”
DistanceFoot“ft”
DistanceYard“yd”
DistanceAngstrom“ang”
DistanceEll“ell”
DistanceLight-year“ly”
DistanceParsec“parsec” or “pc”
DistancePica (1/72 inch)“Picapt” or “Pica”
DistancePica (1/6 inch)“pica”
DistanceU.S survey mile (statute mile)“survey_mi”
TimeYear“yr”
TimeDay“day” or “d”
TimeHour“hr”
TimeMinute“mn” or “min”
TimeSecond“sec” or “s”
PressurePascal“Pa” (or “p”)
PressureAtmosphere“atm” (or “at”)
Pressuremm of Mercury“mmHg”
PressurePSI“psi”
PressureTorr“Torr”
ForceNewton“N”
ForceDyne“dyn” (or “dy”)
ForcePound force“lbf”
ForcePond“pond”
EnergyJoule“J”
EnergyErg“e”
EnergyThermodynamic calorie“c”
EnergyIT calorie“cal”
EnergyElectron volt“eV” (or “ev”)
EnergyHorsepower-hour“HPh” (or “hh”)
EnergyWatt-hour“Wh” (or “wh”)
EnergyFoot-pound“flb”
EnergyBTU“BTU” (or “btu”)
PowerHorsepower“HP” (or “h”)
PowerPferdestärke“PS”
PowerWatt“W” (or “w”)
MagnetismTesla“T”
MagnetismGauss“ga”
TemperatureDegree Celsius“C” (or “cel”)
TemperatureDegree Fahrenheit“F” (or “fah”)
TemperatureKelvin“K” (or “kel”)
TemperatureDegrees Rankine“Rank”
TemperatureDegrees Réaumur“Reau”
VolumeTeaspoon“tsp”
VolumeModern teaspoon“tspm”
VolumeTablespoon“tbs”
VolumeFluid ounce“oz”
VolumeCup“cup”
VolumeU.S. pint“pt” (or “us_pt”)
VolumeU.K. pint“uk_pt”
VolumeQuart“qt”
VolumeImperial quart (U.K.)“uk_qt”
VolumeGallon“gal”
VolumeImperial gallon (U.K.)“uk_gal”
VolumeLiter“l” or “L” (“lt”)
VolumeCubic angstrom“ang3” or “ang^3”
VolumeU.S. oil barrel“barrel”
VolumeU.S. bushel“bushel”
VolumeCubic feet“ft3” or “ft^3”
VolumeCubic inch“in3” or “in^3”
VolumeCubic light-year“ly3” or “ly^3”
VolumeCubic meter“m3” or “m^3”
VolumeCubic Mile“mi3” or “mi^3”
VolumeCubic yard“yd3” or “yd^3”
VolumeCubic nautical mile“Nmi3” or “Nmi^3”
VolumeCubic Pica“Picapt3”, “Picapt^3”, “Pica3” or “Pica^3”
VolumeGross Registered Ton“GRT” (“regton”)
VolumeMeasurement ton (freight ton)“MTON”
AreaInternational acre“uk_acre”
AreaU.S. survey/statute acre“us_acre”
AreaSquare angstrom“ang2″ or “ang^2”
AreaAre“ar”
AreaSquare feet“ft2” or “ft^2”
AreaHectare“ha”
AreaSquare inches“in2” or “in^2”
AreaSquare light-year“ly2” or “ly^2”
AreaSquare meters“m2” or “m^2”
AreaMorgen“Morgen”
AreaSquare miles“mi2” or “mi^2”
AreaSquare nautical miles“Nmi2” or “Nmi^2”
AreaSquare Pica“Picapt2”, “Pica2”, “Pica^2” or “Picapt^2”
AreaSquare yards“yd2” or “yd^2”
InformationBit“bit”
InformationByte“byte”
SpeedAdmiralty knot“admkn”
SpeedKnot“kn”
SpeedMeters per hour“m/h” or “m/hr”
SpeedMeters per second“m/s” or “m/sec”
SpeedMiles per hour“mph”

 

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

PrefixMultiplierAbbreviation
yotta1.00E+24“Y”
zetta1.00E+21“Z”
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“da” or “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”
zepto1.00E-21“z”
yocto1.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

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn