Take a Guess to Win Windows 10 Pro Key!
previous arrow
next arrow
Slider

How to Convert Decimal Number to Binary Number in Excel

Date:2019-11-1 Author:Olivia

Have you ever been bothered by how to convert decimal number to binary number? Fortunately, Microsoft Excel allows to complete the conversion in a simple but effective method. Here is how you can do it:

1. Enter all data of Decimal Number, and select the first row of Binary Number.

How to Convert Decimal Number to Binary Number in Excel

2. Go to Formulas tab and find Function Library group, then click Insert Function.

How to Convert Decimal Number to Binary Number in Excel

3. When the Insert Function dialog box appears, click the arrow of Or select a category, scroll down and select Engineering in the drop-down list.

How to Convert Decimal Number to Binary Number in Excel

4. Next choose DEC2BIN in the box of Select a function, then click OK.

How to Convert Decimal Number to Binary Number in Excel

5. The Function Arguments pop-up window will display, click the box of Number, and select the first row of Decimal Number. After the self-filling is completed, click OK to save the settings.

How to Convert Decimal Number to Binary Number in Excel

6. Now you can see that the decimal number has been converted to binary number in the first row. Drag the selected area to fill the sequence, then you finish all the conversion.

How to Convert Decimal Number to Binary Number in Excel

How to Convert Decimal Number to Binary Number in Excel

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

1 thought on “How to Convert Decimal Number to Binary Number in Excel”

  1. vurtilopmer says:

    You are my inspiration , I have few blogs and rarely run out from to post : (.

Leave a Reply

Your email address will not be published. Required fields are marked *