try this:
A1 = 154.2
B1 = 1700
C1 = A1*B1 give answer 262140 (correct)
D1 = 4
E1 = C1/D1 give answer 100000 (incorrect, the answer must be 65535)

does anyone know this error?

If you run Office Update that should get fixed. Here's a link to the fix:

http://blogs.msdn.com/excel/archive/...available.aspx

--
Biff
Microsoft Excel MVP


"Wilson" wrote in message
...
try this:
A1 = 154.2
B1 = 1700
C1 = A1*B1 give answer 262140 (correct)
D1 = 4
E1 = C1/D1 give answer 100000 (incorrect, the answer must be 65535)

does anyone know this error?

Is is not a miscalculation. The display of the number is wrong. MS has
corrected this, but I cannot remember where the patch is.

Tyro

"Wilson" wrote in message
...
try this:
A1 = 154.2
B1 = 1700
C1 = A1*B1 give answer 262140 (correct)
D1 = 4
E1 = C1/D1 give answer 100000 (incorrect, the answer must be 65535)

does anyone know this error?

That problem was fixed with SP1 update.

Rob

"Wilson" wrote in message
...
try this:
A1 = 154.2
B1 = 1700
C1 = A1*B1 give answer 262140 (correct)
D1 = 4
E1 = C1/D1 give answer 100000 (incorrect, the answer must be 65535)

does anyone know this error?