addiscombe.org

by **Elliot M** » Tue Sep 25, 2007 2:16 pm

I don't know, but given the result is (2^16)-1, ie the largest number that can be stored in 2 bytes (16 bits) ignoring sign, it's something to do with switching between the number of bytes used?

by **Will** » Tue Sep 25, 2007 2:41 pm

It gives me 100,000 which is crazy :shock:

by **adrian** » Tue Sep 25, 2007 3:48 pm

[quote="Seanieh_The PengeAvengerÂ©"]I got 65535, but I'm using Excel 2003

by **adrian** » Tue Sep 25, 2007 4:18 pm

[quote] Wiki has the [url=http://en.wikipedia.org/wiki/65535]answer[/url].
[quote]
In Microsoft Excel 2003 and lower, the maximum amount of rows one was allowed to use was 65535. In Microsoft Office 2007 this has been extended to 1,048,576 (or 2^20) rows.