Tuesday, June 19, 2012

DEC2BIN for up to 24 bits

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

very useful since the excel could support up to 9 bits only.