December 4, 2020

CONVERT function in Google Sheet

The CONVERT function is used to convert a number in one measurement system to another in both Excel & Google Sheet. For example, you can use CONVERT to convert kilograms into pounds, meters into feet, gallons into liters, Celsius to Fahrenheit and for many other unit conversions.

=CONVERT(num, from_unit, to_unit)
  • number – The number to convert.
  • from_unit – The current unit for number.
  • to_unit – The unit into which the number to be converted.

The from_unit & to_unit need to be specified within double quotes.  Please follow the table at the end of this topic to find the commonly used set of units.

In the example below, we have used the CONVERT function to convert the number mentioned in cell A2 from Celsius to Fahrenheit. Note here, CONVERT function is able to handle the negative numbers.

In the example below, we have used the CONVERT function to convert the number mentioned in cell A2 from Meter to feet. Note here, CONVERT function is able to handle decimal numbers as well along with integers.

Notes :

  • The Excel CONVERT function is case-sensitive.
  • CONVERT function will return the #N/A error when a unit string is not recognized.
  • CONVERT function will return the #N/A error when the units are not compatible.
  • CONVERT function will return the #VALUE! error when a number is not valid.
Weight and massUnit
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”)
Gram“g”
Slug“sg”
Pound mass (avoirdupois)“lbm”
U (atomic mass unit)“u”
Ounce mass (avoirdupois)“ozm”
DistanceUnit
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”
Meter“m”
Statute mile“mi”
Nautical mile“Nmi”
Inch“in”
TimeUnit
Year“yr”
Day“day” or “d”
Hour“hr”
Minute“mn” or “min”
Second“sec” or “s”
PressureUnit
PSI“psi”
Torr“Torr”
Pascal“Pa” (or “p”)
Atmosphere“atm” (or “at”)
mm of Mercury“mmHg”
ForceUnit
Pound force“lbf”
Pond“pond”
Newton“N”
Dyne“dyn” (or “dy”)
EnergyUnit
Horsepower-hour“HPh” (or “hh”)
Watt-hour“Wh” (or “wh”)
Foot-pound“flb”
BTU“BTU” (or “btu”)
Joule“J”
Erg“e”
Thermodynamic calorie“c”
IT calorie“cal”
Electron volt“eV” (or “ev”)
PowerUnit
Watt“W” (or “w”)
Horsepower“HP” (or “h”)
Pferdestärke“PS”
MagnetismUnit
Gauss“ga”
Tesla“T”
TemperatureUnit
Degrees Rankine“Rank”
Degrees Réaumur“Reau”
Degree Celsius“C” (or “cel”)
Degree Fahrenheit“F” (or “fah”)
Kelvin“K” (or “kel”)
Liquid measureUnit
Quart“qt”
Imperial quart (U.K.)“uk_qt”
Gallon“gal”
Imperial gallon (U.K.)“uk_gal”
Liter“l” or “L” (“lt”)
Teaspoon“tsp”
Modern teaspoon“tspm”
Tablespoon“tbs”
Fluid ounce“oz”
Cup“cup”
U.S. pint“pt” (or “us_pt”)
U.K. pint“uk_pt”
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
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”
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”
InformationUnit
Byte“byte”
Bit“bit”

Leave a Reply

Your email address will not be published. Required fields are marked *