Converting Decimal to Binary

[Russ]

Anyone know how to convert decimal numbers >= 512 to
binary in Excel? DEC2BIN apparently only work for numbers
up to 511.

Thanks!

 

[Frank Kabel]

Hi
have a look at
http://tinyurl.com/258xf

for a user defined function to do this

 

[Harlan Grove]

Anyone know how to convert decimal numbers >= 512 to
binary in Excel? DEC2BIN apparently only work for numbers
up to 511.

Pick your number apart into powers of 512. For numbers from 0 to -1+2^36,

=DEC2BIN(INT(x/2^27),9)&DEC2BIN(INT(MOD(x,2^27)/2^18),9)
&DEC2BIN(INT(MOD(x,2^18)/2^9),9)&DEC2BIN(MOD(x,2^9),9)