dec2bin


Posted by Mike Lamb on October 29, 2001 9:13 PM

Dec2bin only allows 10 places.
Why is there a way arond this?



Posted by Paul Akkermans on October 30, 2001 5:30 AM

=DEC2BIN((A1/512);9) & DEC2BIN(MOD(A1;512);9)
This should work, decimal value in A1