Formula Friday- Excel Tip- Be A CONVERT


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!

Barbara

Barbara is an experienced data analyst with over 20 years of experience. Author of the How To Excel At Excel Top 50 Excel tips Ebook, YouTuber and Excel Blogger.

Recent Posts