somebody pointed out that Excel is storing the value correctly as 65535, but is setting the text as "100,000".
Here's how to test.
type the equation in cell A1.
Hit Alt+F11, then CTRL+G to get to the "VBA Immediate Window".
Type
print Range("A1").Value
and hit enter. You'll get 65535. If you do .Text instead, you'll get 100000.
Even better, If you make Cell A2 =A1*2, you get 131070. A3 =A1+1 yields 100001. Hmm. ;)
Even better, If you make Cell A2 =A1*2, you get 131070. A3 =A1+1 yields 100001. Hmm. ;)