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.

"boardmaker" wrote:

>
> What I am looking to do is make myself a truth table. Is there anyway I
> can just type zero through 255 and in the next column excel will give
> me it's binary number.
>
>
> --
> boardmaker
> ------------------------------------------------------------------------
> boardmaker's Profile: http://www.excelforum.com/member.php...o&userid=34854
> View this thread: http://www.excelforum.com/showthread...hreadid=551633
>
>