decimal to 16 bits binary conversion in Excel?
 

I'm aware of the function DEC2BIN(), but it has a limitation of 10 bits.
Are there any 16 bits solutions available?


--
xcgames
------------------------------------------------------------------------
xcgames's Profile: http://www.excelforum.com/member.php...o&userid=32842
View this thread: http://www.excelforum.com/showthread...hreadid=526353

decimal to 16 bits binary conversion in Excel?
 

xcgames said the following on 3/26/2006 2:20 PM:
I'm aware of the function DEC2BIN(), but it has a limitation of 10 bits.
Are there any 16 bits solutions available?


See this post you may need to use VBA and break it up.
http://www.dailydoseofexcel.com/arch...mal-to-binary/

decimal to 16 bits binary conversion in Excel?
 

Try this

=DEC2BIN(A1/256,8)&DEC2BIN(MOD(A1,256),8)

always shows 16 bits...


--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: http://www.excelforum.com/member.php...o&userid=30486
View this thread: http://www.excelforum.com/showthread...hreadid=526353