DEC2BIN Function

how to use dec2bin function in excel

You can convert Decimal numbers into binary numbers
The binary numbers contain only 0 and 1 values

DEC2BIN Function has a limit of 511 Decimal numbers
If you write more than 511 characters it will return #NUM error




Number: it is the number you want to convert into binary
Places:[Optional] how many characters you want to show in your result. It will place "0" before the result.


Here we have taken an example of the decimal number and convert it into binary numbers.
We have written a formula  

=DEC2BIN(D4,9) which will convert the decimal number into binary and show result till 9 characters. No character place is fill by 0

On the right side, if you write 511 it will return 9 times "1"
If you write 512 it will return #NUM error


To convert a Decimal number into a Binary number


Binary number

No comments:

Post a Comment