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:


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.