Reply to thread

Message: [QUOTE="Harlan Grove, post: 1160318"] hmmm wrote... If you just want to go up to 2^16-1, one purely built-in way to convert the decimal number x to binary is =MOD(INT(x/2^15),2)&MOD(INT(x/2^14),2)&MOD(INT(x/2^13),2)&MOD(INT(x/2^12),2) &MOD(INT(x/2^11),2)&MOD(INT(x/2^10),2)&MOD(INT(x/2^9),2)&MOD(INT(x/2^8),2) &MOD(INT(x/2^7),2)&MOD(INT(x/2^6),2)&MOD(INT(x/2^5),2)&MOD(INT(x/2^4),2) &MOD(INT(x/2^3),2)&MOD(INT(x/2^2),2)&MOD(INT(x/2),2)&MOD(x,2) And to convert the binary number b to decimal, =SUMPRODUCT(MID(b,ROW(INDIRECT("1:"&LEN(b))),1) *2^(LEN(b)-ROW(INDIRECT("1:"&LEN(b))))) [/QUOTE]