Hey all Excel ers it is Friday again and today we going to be a convert, yes to using the CONVERT function in Excel. This function is one really useful took that should be well and truly in your Excel toolkit.
This little helper will convert a number from one unit of measurement to another. This function only applies to Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007 versions.
The syntax for the formula is
=CONVERT(NUMBER, FROM UNITS, TO UNITS)
Where NUMBER is the number to be converted
FROM UNITS is original units of measure the NUMBER is being converted from
TO UNITS is original units of measure the NUMBER is being converted to
We have a lot of options of the of unit of measure.
“m” | Meter | Length/Distance |
“mi” | Mile | Length/Distance |
“Nmi” | Nautical mile | Length/Distance |
“in” | Inch | Length/Distance |
“ft” | Foot | Length/Distance |
“yd” | Yard | Length/Distance |
“ang” | Angstrom | Length/Distance |
“pica” | Pica | Length/Distance |
“g” | Gram | Weight/Mass |
“sg” | Slug | Weight/Mass |
“lbm” | Pound | Weight/Mass |
“u” | Atomic unit | Weight/Mass |
“ozm” | Ounce | Weight/Mass |
“yr” | Year | Time |
“day” | Day | Time |
“hr” | Hour | Time |
“mn” | Minute | Time |
“sec” | Second | Time |
“C” or “cel” | Celsius | Temperature |
“F” or “fah” | Fahrenheit | Temperature |
“K” or “kel” | Kelvin | Temperature |
“tsp” | Teaspoon | Liquid Volume |
“tbs” | Tablespoon | Liquid Volume |
“oz” | Fluid ounce | Liquid Volume |
“cup” | Cup | Liquid Volume |
“pt” or “us_pt” | US pint | Liquid Volume |
“uk_pt” | UK pint | Liquid Volume |
“qt” | Quart | Liquid Volume |
“gal” | Gallon | Liquid Volume |
“l” or “lt” | Liter | Liquid Volume |
“N” | Newton | Force |
“dyn” or “dy” | Dyne | Force |
“lbf” | Pound Force | Force |
“Pa” or “p” | Pascal | Pressure |
“atm” | Atmosphere | Pressure |
“mmHg” | mm of Mercury | Pressure |
“HP” or “h” | Horsepower | Power |
“W” or “w” | Watt | Power |
“J” | Joule | Energy |
“e” | Erg | Energy |
“c” | Thermodynamic calorie | Energy |
“cal” | IT calorie | Energy |
“eV” or “ev” | Electron volt | Energy |
“HPh” or “hh” | Horsepower-hour | Energy |
“Wh” or “wh” | Watt-hour | Energy |
“flb” | Foot-pound | Energy |
“BTU” or “btu” | BTU | Energy |
“T” | Tesla | Magnetism |
“ga” | Gauss | Magnetism |
Let’s take a look at an example. I find this function really useful especially working out temperature values in Fahrenheit compared their Celsius values, or I used it when my polytunnel was estimated in size in Feet and I needed to see it in Metres. I also found it useful for planning a road trip to the USA I use it for knowing what speed limits are in Kilometers per hour (km/h) when they are published as miles per hour mph
So to convert 35degress
Give this a go. It is one a formula once you know is available is one that you will go back to again and again.
That’s Formula Friday for this week……….Happy Friday!