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

*Syntax*

=DEC2BIN(number,[places])

*Argument*

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.

*Behavior*

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

*Usage*

To convert a Decimal number into a Binary number

*Returns*

Binary number

## No comments:

## Post a Comment