Microsoft Office Tutorials and References
In Depth Information
DEGREES Converts an angle (in radians) to degrees
Converts a hexadecimal number to binary
HEX2DEC Converts a hexadecimal number to decimal
HEX2OCT Converts a hexadecimal number to octal
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.