On Tue, 21 Jun 2005 16:27:02 -0700, KRAMER
wrote:

never
expected that summing of cells formatted as currency with only 2 decimal
places

In Excel, formatting only affects how the contents of the cell are *displayed*.
But unless you have checked the option "Precision as Displayed", the numbers
themselves are stored at the full precision of the program. This frequently
leads to penny off results in calculating sums of currency.


--ron