Excel will only produce binary numbers with up to 10 bits. This means that it can only convert decimal numbers greater than -513 and less than 512.

Press Enter to see the result Launch Microsoft Excel. Create a table with headings Binary and Hex, or use an existing one. Under the hex heading type =BIN2HEX(A2,5). A2 is the Binary number you ...

Excel 2007 has troubles with multiplication when the result is 65,535--a number familiar to those who've dealt with binary numbers. Stephen Shankland worked at CNET from 1998 to 2024 and wrote ...