Bin

Question

111111

Answer 1

But Excel can handle a 32,767 length text entry in a cell. So one can enter a 1023-digit text entry such as: **'**1111111111... and so on, or as I did =REPT(1,1023), this is the formula in A1.

Actually, the formula will not support more than 50 characters long binary numbers as till 2^49, precision is supported by Excel. But 2 ^ 50 will be more than 15 significant digits, hence, you will lose precision.

=REPT(1, 49) is OK but for REPT(1, 50), your formula will not give your correct answer.

You can check it in Python which support unlimited lengths (limited by available memory)

Alternatively, you can check on any online calculator such as https://www.rapidtables.com/convert/number/binary-to-decimal.html

Answer 2

We have no idea what is in either A1, or L20. Perhaps you used helper cells?

> ... binary (1's) to the decimal 8.98846567431158E+307

Binary digits as you are using represent an Integer, not a machine precision number. You don't have enough precision to display the integers. You have to use other excel functions to display the integers.

( A random binary digit in B1, and the decimal "Integer" in B3 )

Answer 3

Hi Shane,

Please check on following

1. The title of says BIN2HEX but looks like there is no HEX in any formula.
2. Your both formulas carry reference to L20, hence both formulas are not working.

Answer 4

Thanks for pointing out these issues. I have edited the original post, hopefully addressing all the issues.

Again thanks,

Shane

Answer 5

Thanks for pointing out these issues. I have edited the original post and hopefully corrected all issues.

Thanks,

Shane