Microsoft Office Tutorials and References

In Depth Information

DEGREES Converts an angle (in radians) to degrees

HEX2BIN

Converts a hexadecimal number to binary

HEX2DEC Converts a hexadecimal number to decimal

HEX2OCT Converts a hexadecimal number to octal

OCT2BIN

Converts an octal number to binary

OCT2DEC Converts an octal number to decimal

OCT2HEX Converts an octal number to hexadecimal

RADIANS Converts an angle (in degrees) to radians

* Function is new to Excel 2013.

Need to convert other units?

The CONVERT function, of course, doesn't handle every possible unit conversion. To calculate other unit conver-

sions, you need to find the appropriate conversion factor. The Internet is a good source for such information. Use

any web search engine and enter search terms that correspond to the units you use. Likely, you'll find the informa-

tion that you need.

Also, you can download a copy of Josh Madison's popular (and free) Convert software. This excellent program

can handle just about any conceivable unit conversion that you throw at it. The URL is
ht-

You can use the program to find the conversion factor and then use that value in your formulas.