Hi S Findlay!

The problem that you are experiencing is because formatting doesn't
alter the numbers that are stored.

There are various approaches:

You could round the numbers that you are adding rather than just
format them. But this changes what numbers are stored.

You could use a summing formula that adds the formatted rounded
numbers.

Example:
=SUM(ROUND(A1:A6,2))
Entered as an array by pressing and holding down Ctrl + Shift and then
pressing Enter.

However, this is really giving a false answer in that it is not the
sum of the numbers that have been formatted.

You could use:
Tools Options Calculation
Check "Precision as displayed"
OK

But this serves to truncate all of the numbers in the workbook to
their current format appearance and that may be undesirable.

Finally, you could live with the problem and annotate your results
appropriately.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia


It is imperative that the patches provided by Microsoft in its April
Security Release be applied to Systems as soon as possible. It is
believed that the likelihood of a worm being released SOON that
exploits one of the vulnerabilities addressed by these patches is VERY
HIGH.
See:
http://www.microsoft.com/security/protect/