Drop extra decimal places

[DejaVu]

I've got a large spreadsheet with a lot of values such as:
1.2315
1.157
2.447
7.1
3.5523

I'm wanting just 2 decimal places, like the following:
1.23
1.16
2.45
7.10
3.55

I can go to FORMAT-CELLS and have it just show 2 decimals, but then my totals are off. It still has the full number as the value, and its throwing all my numbers off.

Any help is greatly appreciated!!

DejaVu

[MartinShort]

http://www.excelforum.com/showthread.php?t=366762