BIN2DEC conversion for large binary numbers
Googling around it seems that Excel can only handle binary numbers <= 511
"Mike H" wrote:
Hi,
Well I think it's 822 and my calculator confirms that and like you I get
-202. Someone will no doubt explain why but in the meantime use this
=SUMPRODUCT(MID("0"&A1,ROW(INDIRECT("1:"&LEN("0"&A 1))),1)*2^(LEN("0"&A1)-ROW(INDIRECT("1:"&LEN("0"&A1)))))
Where your binary number is in A1
Mike
"ahmedmidany" wrote:
Hello All,
I need your help, i want to convert large binary numbers using excel
but whenever i use the BIN2DEC function the result is negative which
is not correct.
Ex. BIN2DEC(1100110110) the result is -202 but if i use the calculator
the result is 822 which is the correct value
Any ideas? what shall i do to have the correct value?
Thanks in advance
A.M.
.
|