Re: [OT] Excell 2007 "65535 --> 100000" bug by "Dennis Crawley" .

Hi, Have you try to change the cell format? On Tuesday, September 25, 2007 4:28 PM [GMT-3=CET], Alex Harford wrote: {Quote hidden}> On 9/25/07, Walter Banks <walterEraseMEbytecraft.com> wrote: > > This seems to be a display bug and not a calculation bug. A function > > in a cell that results in 65535 is displayed wrong but when the cell is > > referenced it produces 65535. > > Not exactly. If you make A2=A1+1, you get a result of 100,001. > > http://groups.google.com/group/microsoft.public.excel/msg/e005c282d888b5fa > > Although if you read the value from VB, it is correct. > > Alex