Using the CONVERT Function

The CONVERT function is one of those obscure little tools in Excel that can come in very handy.

For example, let’s say you want to convert the number of Feet in a measurement to the corresponding number of Meters. CONVERT to the rescue! In fact, CONVERT can translate a Wide Variety of measurements that include time, distance, temperature, weight, and much more.

The Syntax of the CONVERT function is as follows:

CONVERT(Number, From Unit, To Unit) where:

1. Number is the Amount in From Units to convert
2. From Unit are the units Being Converted
3. To Unit are the Units in the Result

The table below shows the results of some of the more Commonly Used Conversions:

For a Full List of all the measures that can be converted, please see the CONVERT function Help topic.

The CONVERT function. It is always there when you need it. Check it out when you have a moment!