Using the Convert Function in Excel

The convert function in Excel converts a number from one measurement to another. For example, CONVERT can translate a table of temperatures from Fahrenheit to Celsius (or vice-versa), miles to kilometers, hours to seconds and much, much, more.

The Syntax of the CONVERT function is:

CONVERT(number,from_unit,to_unit)
Number is the value in from_units to convert.
From_unit is the units for number.
To_unit is the units for the result.

For example, to convert miles units in cell A2 to kilometers, the formula would read:

=CONVERT(A2,”mi”,”km”)

You can see a full list of conversion abbreviations on Microsoft’s Website at:

http://office.microsoft.com/en-us/excel/HP052090221033.aspx

Note that in order to use the CONVERT function, you must have the Analysis TookPak add-in installed.  To do this:

1. Click the Microsoft Office button
2. Click Excel Options
3. Click Add-Ins in the left pane
4. Click Analysis ToolPak
   
5. Click OK.

Similar Posts:

None Found

Tagged as: Excel 2007 Tips, Microsoft Office Tips