Software

Convert measurements to metrics in Excel

Excel offers a function that can save you all kinds of time when you need to convert measurements. Here's a look at how you can put this function to work.

With Excel's CONVERT function, you don't need to know the formulas for converting one unit of measurement to another. For example, say you have a listing of items in Column A, whose length in feet is listed in column B. You need to convert the length from feet to meters before distributing the list to your overseas offices. Follow these steps:

  1. Select C2:C8.
  2. Enter =CONVERT(B2,"ft","m")
  3. Press Ctrl + Enter.
Figure A shows the results.

Figure A

You can use the CONVERT function to convert many kinds of measurements. For example, to convert 68° Fahrenheit to its Centigrade equivalent, you would enter:

=CONVERT(68, "F", "C")

Likewise, to convert back to Fahrenheit, you would enter:

=CONVERT(F2,"C","F")

Figure B shows the both of these functions.

Figure B

See Excel Help for the correct arguments for converting other types of measurements. (Note: If  Excel does not recognize the CONVERT function, you need to load the Analysis ToolPak.)


Miss an Excel tip?

Check out the Microsoft Excel archive and catch up on other Excel tips.

Help users increase productivity by automatically signing up for TechRepublic's free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.

Editor's Picks

Free Newsletters, In your Inbox