Microsoft Office Tutorials and References
In Depth Information
units from one unit to
The DEC2BIN function converts decimal numbers to binar y.
DEC2BIN 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. Negatives are
represented using Two’s complement notation. Notice the example in Figure 5.10. Where the
Decimal Number is 2 and the Places is 3, the conversion to a binar y results in 010.
The number to convert. Cannot be less than –512 or greater than
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.
Converts decimals to