If yous are an Excel 2007 user, endeavor this:
Type =77.1*850 inwards whatever prison theater cellphone together with press Enter. Excel 2007 would supply a value of 100,000 instead of 65,535.
Any combination of numbers that should calculate to 65535 volition exhibit 100000 inwards Excel 2007.
Excel Team says the number is genuinely non inwards the calculation itself (the effect of the calculation stored inwards Excel’s retention is correct), but solely inwards the effect that is shown inwards the sheet.
Said simply about other way, =850*77.1 volition display an wrong value, but if yous together with hence multiply the effect past times 2, yous volition transcend away the right response (i.e. if A1 contains “=850*77.1”, together with A2 contains “=A1*2”, A2 volition supply the right response of 131,070).
I am non certain if that's right because when I type =B1+1 inwards the prison theater cellphone C1, I transcend away 100001 together with non 65536 every 2nd per the official explanation.
Anyway, David Gainer confirmed that this põrnikas was introduced inwards the Excel 2007 version together with a gear upwards for the calculation number would live on available on Microsoft Download Center really soon. It's already nether testing.
Type =77.1*850 inwards whatever prison theater cellphone together with press Enter. Excel 2007 would supply a value of 100,000 instead of 65,535.
Any combination of numbers that should calculate to 65535 volition exhibit 100000 inwards Excel 2007.
Excel Team says the number is genuinely non inwards the calculation itself (the effect of the calculation stored inwards Excel’s retention is correct), but solely inwards the effect that is shown inwards the sheet.
Said simply about other way, =850*77.1 volition display an wrong value, but if yous together with hence multiply the effect past times 2, yous volition transcend away the right response (i.e. if A1 contains “=850*77.1”, together with A2 contains “=A1*2”, A2 volition supply the right response of 131,070).
I am non certain if that's right because when I type =B1+1 inwards the prison theater cellphone C1, I transcend away 100001 together with non 65536 every 2nd per the official explanation.
Anyway, David Gainer confirmed that this põrnikas was introduced inwards the Excel 2007 version together with a gear upwards for the calculation number would live on available on Microsoft Download Center really soon. It's already nether testing.
No comments:
Post a Comment