decimal to binary

[boardmaker]

What I am looking to do is make myself a truth table. Is there anyway
can just type zero through 255 and in the next column excel will giv
me it's binary number

 

[Trevor Shuttleworth]

=DEC2BIN(A1,8) assuming that the number is in cell A1

Regards

Trevor

 

[Arvi Laanemets]

Hi

=DEC2BIN(A1)

NB! Analysis Toolpack must be installed!

Arvi Laanemets

 

[Bearacade]

Use =DEC2BIN(

 

[JLatham]

If column A has your decimal numbers, (and starts in row 1) set this formula
up in B1:
=DEC2BIN(A1)

If it shows a #NAME error, go to Tools | Add-Ins and select the Analysis
Tool Pak and then edit the formula to make it show up right.

Drag the formula down the sheet as far as you need it to go.