Microsoft Office Tutorials and References
In Depth Information
HEX2DEC
HEX2DEC
HEX2DEC converts hexadecimal numbers to decimal.
=HEX2DEC(number)
The HEX2DEC 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. Notice the example in Figure 5.17. The
binar y number is converted to a hexadecimal and then the HEX2DEC function converts the
hexadecimal back to a decimal number. The number cannot be more than 10 characters.
The sign bit being the most significant, the remaining 39 bits are magnitude bits. Negatives
are represented using Two’s complement notation.
The hexadecimal number to convert.
NUMBER
Figure 5.17
Converts hexadecimal
numbers to decimal.
HEX2OCT
Use the HEX2OCT function to convert hexadecimal numbers to octal.
=HEX2OCT(number)
The HEX2OCT 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. Notice the example in Figure 5.18. The binar y
number is converted to a hexadecimal and then the HEX2OCT function converts the
hexadecimal to an octal. The binar y number cannot be more than 10 characters. The sign bit being
the most significant, the remaining 39 bits are magnitude bits. Negatives are represented
using Two’s complement notation.
The binar y number to convert.
NUMBER
The number of characters to use. If places is omitted it uses the
least characters necessar y. If the value is not an integer, the value
is truncated. Use when you want to pad the result with leading
zeros to achieve uniformity.
PLACES
Search JabSto ::




Custom Search