OCT2HEX FunctionWayne Becker20150916T06:52:55+00:00
The OCT2HEX function converts an octal number to hexadecimal number.
Syntax
=OCT2HEX(number,[places])
Note: Hexadecimal (base 16), decimal (base 10), octal (base 8), and binary (base 2) are the most commonly used numeral systems in engineering and computing. Therefore, Excel has provided functions to convert numeric values to and from each of these systems.
Arguments
Argument 
Description 
number 
The octal number you want to convert

• 
The number may not contain more than 10 octal characters (30 bits) 

• 
The most significant bit of number is the sign bit 

• 
The remaining 29 bits are magnitude bits 

• 
Negative numbers are represented using two’scomplement notation 

[places] 
Optional. Defines the number of characters to use

• 
If [places] is greater than the minimum, the hexadecimal number will be padded out using leading zeros 

• 
If [places] is omitted, OCT2HEX uses the minimum number of characters necessary 

Examples

A 
B 
C 
1 
Formula 
Result 
nowrap 
2 
=OCT2HEX(100, 4) 
0040 
Converts octal number 100 to hexadecimal form with 4 characters 
3 
=OCT2HEX(7777777533) 
FFFFFFFF5B 
Converts octal number 7777777533 to hexadecimal form 
4 
=OCT2HEX(“763”) 
1F3 
Converts octal number 763 to hexadecimal form 
Common Function Error(s)
Problem 
What went wrong 
#VALUE! 
Occurs if the supplied [places] argument is not recognized as a number 
#NUM! 
Occurs if either:

• 
the supplied number argument is not recognized as an octal number 

• 
the supplied number argument contains more than 10 characters 

• 
the resulting hexadecimal number requires more places than is specified by the supplied [places] argument 

• 
the supplied [places] argument ≤ 0 

#NAME? 
Occurs when Analysis ToolPak addin is not enabled 