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?

Try this

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

always shows 16 bits...

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/

This equation will give the 1 bit to 16 bits conversion from hex to binary. for all Dec to convert the original number to hex and use this.
=HEX2BIN(MID($B$47,1,IF(LEN($B$47)<2,0,LEN($B$47)-2)))&HEX2BIN(MID($B$47,IF(LEN($B$47)<=2, 1, 1+LEN($B$47)-2), IF(LEN($B$47)<2, 1,2)))