Hello, sorry my english is not too good, hopefully somebody understands this?

Problem with rounding, Excel 2003:

A...........B
11325 11
11814 12
11769 12
11552 12
46460 47

Column B is column A rounded to thousands, the last row is sum of the numbers above. Obviously, the rounded total is not correct.

Question: How to format cells in column B so that despite of rounding, accuracy in calculation is maintained and the result would be rounded to 46?

Problem: Even if the accurary is maintained, the results seems wrong on display, when looking just the column B: 11+12+12+12<>46. How to solve this? It seems to me that the only way would be to round e.g. the last number 11552 slightly incorrectly to 11: 11+12+12+11=46. How to tell this to Excel, to round numbers incorrectly so that accuracy on display would be achieved, beginning from the number, where the original rounding error would be smallest?

Many thanks in advance!