Microsoft excel is wierd ... well, not really....

[elxr06]

You know microsoft excel can do math calculations. adding, multiplying, dividing and subtracting.

Try this calculation if you have excel 2007
850*77.1. See what you get.

Then do the exact same calculation using a calculator, or even the calculator that comes with windows!

It seems that microsoft has forgotten how to multiply! (or maybe its coding works screwed up)

[contrex]

This is a by now well known bug in Excel 2007.

I'm guessing what happened here is that there's an off-by-1 error in a comparison somewhere (i.e. ">= 65535" instead of "> 65535"), and the 32-bit quotient/remainder print routine kicks in. Since the number is already smaller than 100000, it probably hits a fall-thru case where the quotient is assumed to be 1, and there's no remainder, hence it is printing 100000.

[elxr06]

yeah, i know, i was wondering what the problem was.

[Comp Guy]

So decimal #s confuse Excel?

[contrex]

So decimal #s confuse Excel?

They confuse coders who forget to check that they really meant > 100000 and not >= 0x100000

[kuszmania9999]

Microsoft know this?

[Spero-T]

This is a by now well known bug in Excel 2007.

I belive they do know

[contrex]

Microsoft know this?

[kuszmania9999]

hm...i found lot of people talking "microsoft have bugs more than apple"

[Deerpark]

For anyone who's interested here's a guy with a pretty good explanation of the bug.
http://www.joelonsoftware.com/items/2007/09/26b.html

[patio]

hm...i found lot of people talking "microsoft have bugs more than apple"

If 90% of the population is running Windows and 10% running MAC products how many Windows problems will you hear about compared to MAC problems ? ?
Do the math.
Every OS / program has it's issues...

[elxr06]

hm...i found lot of people talking "microsoft have bugs more than apple"

If 90% of the population is running Windows and 10% running MAC products how many Windows problems will you hear about compared to MAC problems ? ?
Do the math.
Every OS / program has it's issues...

Yeah. like macOSX can not run software or games made only for windows directly from osx without any windows emulation software ...

Or that people say vista is a memory / resource hog ....