| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. -- boardmaker ------------------------------------------------------------------------ boardmaker's Profile: http://www.excelforum.com/member.php...o&userid=34854 View this thread: http://www.excelforum.com/showthread...hreadid=551633 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
decimal to binary
=DEC2BIN(A1,8) assuming that the number is in cell A1
Regards Trevor "boardmaker" wrote in message ... 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
decimal to binary
Hi
=DEC2BIN(A1) NB! Analysis Toolpack must be installed! Arvi Laanemets "boardmaker" wrote in message ... 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
decimal to binary
Use =DEC2BIN() -- Bearacade ------------------------------------------------------------------------ Bearacade's Profile: http://www.excelforum.com/member.php...o&userid=35016 View this thread: http://www.excelforum.com/showthread...hreadid=551633 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
decimal to binary
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| decimal to binary conversion | Excel Worksheet Functions | |||
| decimal to 16 bits binary conversion in Excel? | Excel Worksheet Functions | |||
| Excel adds phantom decimal places: why? | Excel Discussion (Misc queries) | |||
| How can I convert binary numbers to decimal when they are larger . | Excel Worksheet Functions | |||
| Decimal to Binary | Excel Worksheet Functions | |||
Linear Mode
