Microsoft Office Tutorials and References
In Depth Information
Tip 43: Converting Between Measurement Systems
The CONVERT function is even more versatile than it seems. When using metric units, you can apply a
multiplier. In fact, the first example I presented uses a multiplier. The unit abbreviation for the third
argument is for meters. I added the kilo-multiplier ( k) to express the result in kilometers.
In some situations, the CONVERT function requires some creativity. For example, if you need to
convert 100 km/hour into miles/sec, the formula requires two uses of the CONVERT function:
The CONVERT function has been significantly enhanced in Excel 2013 and supports dozens of new
If you can’t find a particular unit that works with the CONVERT function, perhaps Excel has another
function that will do the job. Table 43-1 lists some other functions that convert between
Table 43-1: Other Conversion Functions
Converts an Arabic number to decimal.
Converts a decimal number to a specified base.
Converts a binary number to decimal.
Converts a binary number to octal.
Converts a decimal number to binary.
Converts a decimal number to hexadecimal.
Converts a decimal number to octal.
Converts an angle (in radians) to degrees.
Converts a hexadecimal number to binary.
Converts a hexadecimal number to decimal.
Converts a hexadecimal number to octal.
Converts an octal number to binary.
Converts an octal number to decimal.
Converts an octal number to hexadecimal.
Converts an angle (in degrees) to radians.
* Function is new to Excel 2013.