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 mass
Unit
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”)
Distance
Unit
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”
Time
Unit
Year
“yr”
Day
“day” or “d”
Hour
“hr”
Minute
“mn” or “min”
Second
“sec” or “s”
Pressure and Its Units
Pressure
Unit
Pascal
“Pa” (or “p”)
Atmosphere
“atm” (or “at”)
mm of Mercury
“mmHg”
PSI
“psi”
Torr
“Torr”
Force
Unit
Newton
“N”
Dyne
“dyn” (or “dy”)
Pound force
“lbf”
Pond
“pond”
Energy
Unit
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”)
Power
Unit
Horsepower
“HP” (or “h”)
Pferdestärke
“PS”
Watt
“W” (or “w”)
Magnetism
Unit
Tesla
“T”
Gauss
“ga”
Temperature
Unit
Degree Celsius
“C” (or “cel”)
Degree Fahrenheit
“F” (or “fah”)
Kelvin
“K” (or “kel”)
Degrees Rankine
“Rank”
Degrees Réaumur
“Reau”
Liquid measure
Unit
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”)
Volume
Unit
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”
Area
Unit
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”
Information
Unit
Bit
“bit”
Byte
“byte”
Metric prefixes
Prefix
Multiplier
Abbreviation
yotta
1E+24
“Y”
zetta
1E+21
“Z”
exa
1E+18
“E”
peta
1E+15
“P”
tera
1E+12
“T”
giga
1000000000
“G”
mega
1000000
“M”
kilo
1000
“k”
hecto
100
“h”
dekao
10
“da” or “e”
deci
0.1
“d”
centi
0.01
“c”
milli
0.001
“m”
micro
0.000001
“u”
nano
0.000000001
“n”
pico
1E-12
“p”
femto
1E-15
“f”
atto
1E-18
“a”
zepto
1E-21
“z”
yocto
1E-24
“y”
Binary prefixes
Binary Prefix
Value
Abbreviation
Decimal
yobi
2^80
“Yi”
yotta
zebi
2^70
“Zi”
zetta
exbi
2^60
“Ei”
exa
pebi
2^50
“Pi”
peta
tebi
2^40
“Ti”
tera
gibi
2^30
“Gi”
giga
mebi
2^20
“Mi”
mega
kibi
2^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
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.
