Learn 100% online from anywhere in the world. Enroll 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 Excel 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, feet to centimeters, or Fahrenheit to Celsius. Learn Excel unit conversion in this guide.



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


The Excel CONVERT function uses the following arguments:

  1. Number (required argument) – 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”
Pound mass (avoirdupois)Ibm
U (atomic mass unit)u
Ounce mass (avoirdupois)ozm
U.S. (short) hundredweightcwt or shweight
Imperial hundredweightuk_cwt or lcwt (hweight)
Imperial tonimperial ton


For Distance, CONVERT accepts the following:

Distance“From unit” or “to unit”
Statute milemi
Nautical mileNmi
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”
Dayday or d
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


For Force, CONVERT accepts the following:

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


For Energy, CONVERT accepts the following:

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


For Power, CONVERT accepts the following:

Power“From unit” or “to unit”
HorsepowerHP (orh)


For Magnetism, CONVERT accepts the following:

Magnetism“From unit” or “to unit”


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”
Modern teaspoontspm
Fluid ounceoz
U.S. pintpt (or us_pt)
U.K. pintuk_pt
Imperial quart (U.K.)uk_qt
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
Square feetft2 or ft^2
Square inchesin2 or in^2
Square light-yearly2 or ly^2
Square metersm2 or m^2
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”


For Speed, CONVERT accepts the following:

Speed“From unit” or “to unit”
Admiralty knotadmkn
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 the Excel CONVERT function. 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 CFI 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!