Microsoft Office Tutorials and References
In Depth Information
Tip 43: Converting Between Measurement Systems
Converting Between Measurement
Systems
You know the distance from New York to London in miles, but your European office needs the
numbers in kilometers. What’s the conversion factor?
The Excel CONVERT function can convert between a variety of measurements in these categories:
➤ Area
➤ Distance
➤ Energy
➤ Force
➤ Information
➤ Magnetism
➤ Power
➤ Pressure
➤ Speed
➤ Temperature
➤ Time
➤ Volume (or liquid measure)
➤ Weight and mass
The CONVERT function requires three arguments: the value to be converted, the from-unit, and the
to-unit. For example, if cell A1 contains a distance expressed in miles, use this formula to convert
miles to kilometers:
=CONVERT(A1,”mi”,”km”)
The second and third arguments are unit abbreviations, which are listed in the Help system. Some
abbreviations are commonly used, but others aren’t. And, of course, you must use the exact
abbreviation. Furthermore, the unit abbreviations are case-sensitive, so the following formula returns an error:
=CONVERT(A1,”Mi”,”km”)
Search JabSto ::




Custom Search