decimal to binary

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.

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

Regards

Trevor


"boardmaker" <boardmaker.29cvwz_1150227902.1821@excelforum-nospam.com> wrote
in message news:boardmaker.29cvwz_1150227902.1821@excelforum-nospam.com...
>
> 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
>

Hi

=DEC2BIN(A1)

NB! Analysis Toolpack must be installed!

Arvi Laanemets



"boardmaker" <boardmaker.29cvwz_1150227902.1821@excelforum-nospam.com> wrote
in message news:boardmaker.29cvwz_1150227902.1821@excelforum-nospam.com...
>
> 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
>

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
>
>