Do you know how to convert binary numbers to decimal?
It’s easy with the BIN2DEC function, but there’s a limitation and an easy way to make a mistake and get a wrong result. The limitation is that it can’t convert a number with more than 10 bits. If you try, it will give an error. There’s also an easy way to make a mistake. If you use numbers that have 10 bits, they may be converted to a negative number. For an explanation, you need to understand the “Two’s complement” method of representing binary integers.
I found this article by Excel MVP Frédéric LE GUEN, that provides a workaround to the 10 bit limitation of the BIN2DEC function:
Convert Binary Number to Decimal in Excel :keycap_0: :keycap_1: (excel-tutorial.com)
It’s easy with the BIN2DEC function, but there’s a limitation and an easy way to make a mistake and get a wrong result. The limitation is that it can’t convert a number with more than 10 bits. If you try, it will give an error. There’s also an easy way to make a mistake. If you use numbers that have 10 bits, they may be converted to a negative number. For an explanation, you need to understand the “Two’s complement” method of representing binary integers. I found this article by Excel MVP Frédéric LE GUEN, that provides a workaround to the 10 bit limitation of the BIN2DEC function: Convert Binary Number to Decimal in Excel :keycap_0: :keycap_1: (excel-tutorial.com) Read More
