Earn your certification as a Financial Modeling & Valuation Analyst (FMVA)®. Register today!

CONVERT Function

Converts a number from one measurement system to another

What is the Excel CONVERT units Function?

The Excel CONVERT Function is an Engineering Function. The function is useful for conversion of units from one measurement system to another measurement system. For example, CONVERT will help us to convert pounds to kilograms or feet to centimeters, Fahrenheit to Celsius, among others. Learn Excel unit conversion in this guide.

 

Formula

=CONVERT(number, “from unit “,”to unit”)

 

The Excel CONVERT function uses the following arguments:

  1. Number (required argument) – It is the numeric value we wish to convert.
  2. From Unit – This is the unit you are converting from. Quotations are necessary!
  3. To Unit – This is the unit you are trying to convert to. Quotations are necessary!

The function accepts certain text values for from_unit to_unit. They are:

Weight & Mass“From unit” or “to unit”
Gramg
Slugsg
Pound mass (avoirdupois)Ibm
U (atomic mass unit)u
Ounce mass (avoirdupois)ozm
Graingrain
U.S. (short) hundredweightcwt or shweight
Imperial hundredweightuk_cwt or lcwt (hweight)
StoneStone
Tonton
Imperial tonimperial ton

 

For Distance, CONVERT accepts the following:

Distance“From unit” or “to unit”
Meterm
Statute milemi
Nautical mileNmi
Inchin
Footft
Yardyd
Angstromang
EIIeII
Light-Yearly
Parsecparsec or pc
Pica (1/72 inch)Picapt or Pica
Pica (1/6 inch)pica
U.S survey mile (statute mile)survey_mi

 

For Time, CONVERT accepts the following:

Time“From unit” or “to unit”
Yearyr
Dayday or d
Hourhr
Minutemn or min
SecondSec or s

 

For Pressure, CONVERT accepts the following

Pressure“From unit” or “to unit”
PascalPa (or p)
Atmosphereatm (or at)
mm of MercurymmHg
PSIpsi
TorrTorr

 

For Force, CONVERT accepts the following:

Force“From unit” or “to unit”
NewtonN
Dynedyn (ordy)
Pound forceibf
Pondpond

 

For Energy, CONVERT accepts the following:

Energy“From unit” or “to unit”
JouleJ
Erge
Thermodynamic caloriec
IT caloriecal
Electron volteV (or ev)
Horsepower-hourHPh (or hh)
Watt-hourWh (or wh)
Foot-poundflb
BTUBTU (or btu)

 

For Power, CONVERT accepts the following:

Power“From unit” or “to unit”
HorsepowerHP (orh)
PferdestärkePS

             

For Magnetism, CONVERT accepts the following:

Magnetism“From unit” or “to unit”
TeslaT
Gaussga

 

For Temperature, CONVERT accepts the following:

Temperature“From unit” or “to unit”
Degree CelsiusC (or cel)
Degree FahrenheitF (or fah)
KelvinK (or kel)
Degrees RankineRank
Degrees RéaumurReau

 

For Volume, CONVERT accepts the following:

Volume (or liquid measure )“From unit” or “to unit”
Teaspoontsp
Modern teaspoontspm
Tablespoontbs
Fluid ounceoz
Cupcup
U.S. pintpt (or us_pt)
U.K. pintuk_pt
Quartqt
Imperial quart (U.K.)uk_qt
Gallongal
Imperial gallon (U.K.)uk_gal
Literl or L (lt)
Cubic angstromang3 or ang^3
U.S. oil barrelbarrel
U.S. bushelbushel
Cubic feetft3 or ft^3
Cubic inchin3 or in^3
Cubic light-yearly3 or ly^3
Cubic meterm3 or m^3
Cubic Milemi3 or mi^3
Cubic yardyd3 or yd^3
Cubic nautical mileNmi3 or Nmi^3
Cubic PicaPicapt3, Picapt^3, Pica3 or Pica^3
Gross Registered TonGRT (regton)
Measurement ton (freight ton)MTON

 

For Area, CONVERT accepts the following:

Area“From unit” or “to unit”
International acreuk_acre
U.S. survey/statute acreus_acre
Square angstromang2 or ang^2
Arear
Square feetft2 or ft^2
Hectareha
Square inchesin2 or in^2
Square light-yearly2 or ly^2
Square metersm2 or m^2
MorgenMorgen
Square milesmi2 or mi^2
Square nautical milesNmi2 or Nmi^2
Square PicaPicapt2, Pica2, Pica^2 or Picapt^2
Square yardsyd2 or yd^2

             

For Information, CONVERT accepts the following:

Information“From unit” or “to unit”
Bitbit
Bytebyte

 

For Speed, CONVERT accepts the following:

Speed“From unit” or “to unit”
Admiralty knotadmkn
Knotkn
Meters per hourm/h or m/hr
Meters per secondm/s or m/sec
Miles per hourmph 

 

We can use the following abbreviated unit prefixes for any metric “From unit” or “to unit”:

 

Excel CONVERT units Function - Prefixes

How to use the Excel CONVERT units function?                           

To understand the uses of the Excel CONVERT units function, let us consider a few examples:

 

CONVERT Function

 

Notes about converting units in Excel:

  1. When the data types are incorrect, we will get #VALUE! error.
  2. The units and prefixes are case-sensitive.
  3. #N/A error occurs when:
    • The given unit does not exist.
    • When the unit doesn’t support the binary prefix.
    • When units are in different groups.

 

Click here to download the sample Excel file

 

Additional resources

Thanks for reading CFI’s guide to important Excel functions! By taking the time to learn and master these functions, you’ll significantly speed up your financial analysis. To learn more, check out these additional resources:

  • Excel Functions for Finance
  • Advanced Excel Formulas Course
  • Advanced Excel Formulas You Must Know
  • Excel Shortcuts for PC and Mac

Free Excel Tutorial

To master the art of Excel, check out CFI’s FREE Excel Crash Course, which teaches you how to become an Excel power user.  Learn the most important formulas, functions, and shortcuts to become confident in your financial analysis.

 

Launch CFI’s Free Excel Course now to take your career to the next level and move up the ladder!