BIN2DEC conversion for large binary numbers
Ron,
100% definitely not in my E2007 just the intro header I posted in my other
post then a description of the syntax for each of the formulae.
Excel 2007 (12.0.6514.5000) SP2 MSO (12.0.6425.1000)
Mike
"Ron Rosenfeld" wrote:
On Tue, 15 Dec 2009 11:14:01 -0800, Mike H
wrote:
I just checked E2003 and you are correct but there is no such explanation of
this limitation in E2007 help reproduced below
That's funny. With Excel 2007, when I look at HELP for BIN2DEC, I see:
Number is the binary number you want to convert. Number cannot contain more
than 10 characters (10 bits). The most significant bit of number is the sign
bit. The remaining 9 bits are magnitude bits. Negative numbers are represented
using two's-complement notation.
Seems pretty clear to me.
--ron
.
|