Microsoft Office Tutorials and References
In Depth Information
BIN2HEX
BIN2HEX
Convert a binar y number to hexadecimal with the BIN2HEX function.
=BIN2HEX(number,places)
The BIN2HEX function is found only if the Analysis Toolpak is installed. In addition it must be
turned on in the Add-Ins from the Tools menu. The number cannot be more than 10
characters. The sign bit being the most significant, the remaining 9 bits are magnitude bits. Notice
the example in Figure 5.6. Where the Binar y Number is 10000010 and the Places is 3, the
conversion to a hexadecimal results in 082.
The binar y number to convert.
NUMBER
The number of characters to use. If omitted, the function uses the
minimum number of characters needed. Use when you want to
PLACES
Figure 5.6
This function converts a
binary number to a
number cannot be more
than 10 characters.
BIN2OCT
BIN2OCT converts a binar y number to octal.
=BIN2OCT(number,places)
The BIN2OCT function is found only if the Analysis Toolpak is installed. In addition it must be
turned on in the Add-Ins from the Tools menu. The binar y number cannot be more than 10
characters. The sign bit being the most significant, the remaining 9 bits are magnitude bits.
Negatives are represented using Two’s complement notation. Notice the example in Figure
5.7, where the Binar y Number is 10000010 and the Places is 3, the conversion to an Octal
results in 202.
The binar y number to convert.
NUMBER
The number of characters to use. If omitted, the function uses the
minimum number of characters needed. Use when you want to