HomeMicrosoft OfficeExcelCONVERT Function in Excel

CONVERT Function in Excel

In this article, you will learn about the CONVERT function, its usage, syntax, and how to use it in your excel spreadsheet.

CONVERT Function in Excel

The CONVERT Function in Excel will convert a number in one measurement (Units) system to another.

Syntax

=CONVERT (number, from_unit, to_unit)

Arguments

  • number – The numeric value to convert.
  • from_unit – The unit in which the number is.
  • to_unit – The units in which the you need to change.

Measurement units

The below table shows the measurements and its units

Weight and massUnit
Gram“g”
Slug“sg”
Pound mass (avoirdupois)“lbm”
U (atomic mass unit)“u”
Ounce mass (avoirdupois)“ozm”
Grain“grain”
U.S. (short) hundredweight“cwt” or “shweight”
Imperial hundredweight“uk_cwt” or “lcwt” (“hweight”)
Stone“stone”
Ton“ton”
Imperial ton“uk_ton” or “LTON” (“brton”)
  
DistanceUnit
Meter“m”
Statute mile“mi”
Nautical mile“Nmi”
Inch“in”
Foot“ft”
Yard“yd”
Angstrom“ang”
Ell“ell”
Light-year“ly”
Parsec“parsec” or “pc”
Pica (1/72 inch)“Picapt” or “Pica”
Pica (1/6 inch)“pica”
U.S survey mile (statute mile)“survey_mi”
TimeUnit
Year“yr”
Day“day” or “d”
Hour“hr”
Minute“mn” or “min”
Second“sec” or “s”

Pressure and Its Units

PressureUnit
Pascal“Pa” (or “p”)
Atmosphere“atm” (or “at”)
mm of Mercury“mmHg”
PSI“psi”
Torr“Torr”
ForceUnit
Newton“N”
Dyne“dyn” (or “dy”)
Pound force“lbf”
Pond“pond”
EnergyUnit
Joule“J”
Erg“e”
Thermodynamic calorie“c”
IT calorie“cal”
Electron volt“eV” (or “ev”)
Horsepower-hour“HPh” (or “hh”)
Watt-hour“Wh” (or “wh”)
Foot-pound“flb”
BTU“BTU” (or “btu”)
PowerUnit
Horsepower“HP” (or “h”)
Pferdestärke“PS”
Watt“W” (or “w”)
MagnetismUnit
Tesla“T”
Gauss“ga”
TemperatureUnit
Degree Celsius“C” (or “cel”)
Degree Fahrenheit“F” (or “fah”)
Kelvin“K” (or “kel”)
Degrees Rankine“Rank”
Degrees Réaumur“Reau”
Liquid measureUnit
Teaspoon“tsp”
Modern teaspoon“tspm”
Tablespoon“tbs”
Fluid ounce“oz”
Cup“cup”
U.S. pint“pt” (or “us_pt”)
U.K. pint“uk_pt”
Quart“qt”
Imperial quart (U.K.)“uk_qt”
Gallon“gal”
Imperial gallon (U.K.)“uk_gal”
Liter“l” or “L” (“lt”)
VolumeUnit
Cubic angstrom“ang3” or “ang^3”
U.S. oil barrel“barrel”
U.S. bushel“bushel”
Cubic feet“ft3” or “ft^3”
Cubic inch“in3” or “in^3”
Cubic light-year“ly3” or “ly^3”
Cubic meter“m3” or “m^3”
Cubic Mile“mi3” or “mi^3”
Cubic yard“yd3” or “yd^3”
Cubic nautical mile“Nmi3” or “Nmi^3”
Cubic Pica“Picapt3”, “Picapt^3”, “Pica3” or “Pica^3”
Gross Registered Ton“GRT” (“regton”)
Measurement ton (freight ton)“MTON”
AreaUnit 
International acre“uk_acre” 
U.S. survey/statute acre“us_acre” 
Square angstrom“ang2″ or “ang^2” 
Are“ar” 
Square feet“ft2” or “ft^2” 
Hectare“ha” 
Square inches“in2” or “in^2” 
Square light-year“ly2” or “ly^2” 
Square meters“m2” or “m^2” 
Morgen“Morgen” 
Square miles“mi2” or “mi^2” 
Square nautical miles“Nmi2” or “Nmi^2” 
Square Pica“Picapt2”, “Pica2”, “Pica^2” or “Picapt^2” 
Square yards“yd2” or “yd^2” 
InformationUnit
Bit“bit”
Byte“byte”

Metric prefixes

PrefixMultiplierAbbreviation
yotta1E+24“Y”
zetta1E+21“Z”
exa1E+18“E”
peta1E+15“P”
tera1E+12“T”
giga1000000000“G”
mega1000000“M”
kilo1000“k”
hecto100“h”
dekao10“da” or “e”
deci0.1“d”
centi0.01“c”
milli0.001“m”
micro0.000001“u”
nano0.000000001“n”
pico1E-12“p”
femto1E-15“f”
atto1E-18“a”
zepto1E-21“z”
yocto1E-24“y”

Binary prefixes

Binary PrefixValueAbbreviationDecimal
yobi2^80“Yi”yotta
zebi2^70“Zi”zetta
exbi2^60“Ei”exa
pebi2^50“Pi”peta
tebi2^40“Ti”tera
gibi2^30“Gi”giga
mebi2^20“Mi”mega
kibi2^10“ki”kilo

How to use the CONVERT function in Excel?

Using this function in a Worksheet is simple, all you need to do is enter the function as a formula of the cell in the formula bar.

Take a look at the given example

How to use the CONVERT function in Excel?

To find out the converted value of the given values, Enter the original value in column A and the unit of the value in Column B, and in Column C, enter the unit in which you need to convert the value. Now enter the following formula in Column D

Formula: =CONVERT(A1,B1,C1)

Here, A1 refers to the cell name or the cell address. Repeat the same to the other cells and you will get the converted value.

Leave a Reply

You May Also Like

In this article, you will learn about the SKEW.P function, the formula syntax and usage of the function in Microsoft...
In this article, you will learn about the SKEW function, the formula syntax and usage of the function in Microsoft...
In this article, you will learn about the RANK.EQ function, the formula syntax and usage of the function in Microsoft...
  • Excel
  • November 23, 2021