X xcgames Mar 26, 2006 #1 I'm aware of the function DEC2BIN(), but it has a limitation of 10 bits. Are there any 16 bits solutions available?
I'm aware of the function DEC2BIN(), but it has a limitation of 10 bits. Are there any 16 bits solutions available?
P Philippe L. Balmanno Mar 27, 2006 #2 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? Click to expand... See this post you may need to use VBA and break it up. http://www.dailydoseofexcel.com/archives/2005/12/02/decimal-to-binary/
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? Click to expand... See this post you may need to use VBA and break it up. http://www.dailydoseofexcel.com/archives/2005/12/02/decimal-to-binary/
D daddylonglegs Mar 27, 2006 #3 Try this =DEC2BIN(A1/256,8)&DEC2BIN(MOD(A1,256),8) always shows 16 bits...
