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

pad the result with leading zeros.

PLACES

Figure 5.6

This function converts a

binary number to a

hexadecimal. The binary

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

pad the result with leading zeros to achieve uniformity.

PLACES