dec2bin Home Board Archive Index Excel Formulas 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