March 11, 2021

# 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 mass Unit 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” Distance Unit 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” Time Unit Year “yr” Day “day” or “d” Hour “hr” Minute “mn” or “min” Second “sec” or “s” Pressure Unit PSI “psi” Torr “Torr” Pascal “Pa” (or “p”) Atmosphere “atm” (or “at”) mm of Mercury “mmHg” Force Unit Pound force “lbf” Pond “pond” Newton “N” Dyne “dyn” (or “dy”) Energy Unit 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”) Power Unit Watt “W” (or “w”) Horsepower “HP” (or “h”) Pferdestärke “PS” Magnetism Unit Gauss “ga” Tesla “T” Temperature Unit Degrees Rankine “Rank” Degrees Réaumur “Reau” Degree Celsius “C” (or “cel”) Degree Fahrenheit “F” (or “fah”) Kelvin “K” (or “kel”) Liquid measure Unit 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” 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 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” Information Unit Byte “byte” Bit “bit”

#### abhraisraja

View all posts by abhraisraja →