Menu
Cart 0

How to Convert Units of Measure in Excel

Posted by Roger Hyttinen on

If you need to convert values from one unit of measure to another, Excel’s CONVERT function just might do the trick. What this does is takes the values from one system and converts it to another. For instance, you can convert ounces to milliliters, teaspoons to tablespoons or Degrees Fahrenheit to Degrees Celsius.

The syntax of the function is:

=CONVERT(number or cell reference), “from_unit”, “to_unit”)

For instance, if we had a value in cell A1 in feet that we wanted to convert to yards, the function would read:

=CONVERT (A1, “ft”, “yd”)

Note that the from_unit and the to_unit need to be surrounded by parenthesis.

You can use the function to convert measurement units in the following categories:

  • Area
  • Distance
  • Energy
  • Force
  • Information
  • Liquid
  • Magnetism
  • Power
  • Pressure
  • Speed
  • Temperature
  • Time
  • Weight & Mass

To get you started, below are some common abbreviations that you can use in the formula:

  • Cubic Feet - “ft3”
  • Cup – “cup”
  • Degrees Fahrenheit – “fah”
  • Degrees Celsius – “cel”
  • Foot “ft”
  • Gram “g”
  • Hectare – “ha”
  • Horsepower – “h”
  • Hour – “hr”
  • Kilometer - “km”
  • Light-year - “ly”
  • Meter “m”
  • Mile (Statute) – “mi”
  • Mile (Nautical) – “Nmi”
  • Minute – “mn”
  • Pint (US) – “pt”
  • Pint (UK) – “uk_pt”
  • Pound Mass - “lbm”
  • Second – “sec”
  • Teaspoon – “tsp”
  • Tablespoon “tbs”
  • Ton – “ton”
  • Watt – “w”
  • Yard – “yd”
  • Year “yr”

Looking for more Excel tips? Check out our new book Excel 2016:Up To Speed available as an ebook on Amazon, Kobo, and Apple iBooks


Share this post



← Older Post Newer Post →


Leave a comment

Please note, comments must be approved before they are published.