BIN2DEC conversion for large binary numbers
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.
|