XLPadawan
Member
Excel's DEC2BIN function only allows for binary number lengths up to 10 digits. How would I make a function from the code I've provided that would allow me to replace the DEC2BIN function used on the UseNewFunc tab and extend it downward to eliminate the #NUM! errors? The arguments for the function (in columns A and D) would be supplied to cell D6 (in tab DEC2BINX), returning the result from H3 as the function value.