Simple division problem

[Roger Fink]

Can anyone explain under what circumstances a simple division formula, say:
=SUM(B29/H29) in Excel 2000 would yield 0 (zero) as a result, rather than
the actual quotient? When I multiply the cell values: =SUM(B29*H29) the
cell produces the correct number. Likewise, there is no problem with
addition or subtraction.

 

[Roger Fink]

FWIW, I figured out the source of the problem. The cell was formatted to
zero decimal places and the quotient was less than one - the zero number was
actually correct. Kind of a dumb mistake, but on the other hand it's
reassuring to know that the program's claim that it can handle division is
correct.

 

[Steve Rindsberg]

<g> Don't you just hate when that happens?

But wouldn't that be a nice feature ... the ability to toggle formatting
on/off for the entire worksheet?

(Who knows ... maybe you can?)

 

[Roger Fink]

The one place where one of those language-mangling, semi-intelligible,
Microsoft popups would have been useful and they're out to lunch.....

 

[Steve Rindsberg]

The one place where one of those language-mangling, semi-intelligible,
Microsoft popups would have been useful and they're out to lunch.....

Even better! If only it existed. Foo.