I have two columns of data - in column A are quantities of goods (which cost
..025p each), in Column B is the total cost, arrived at by "=A1*.025" etc.
Column B is corrected to 2 decimal places to give a usable finance figure,
but if I SUM column B, instead of adding the figures shown, it adds the
uncorrected amounts (ie 3 decimal places) which ends up in a total which
doesn't match the visible figures. This sounds like it should be quite
simple to correct, I just don't seem to be able to find the answer. I am
using Office 2003 and column B is formatted to exclude zero figures. Hope I
have explained clearly!