I have a sheet with columns formatted as money and sometimes due to calculations, the final value is often off by a penny depending on the actual value of the cell and the displayed value of the cell.

Actual values:

12.4999
14.599
9.995
4.5899
22.4949
19.1889

Total
----------
41.6838


Displayed values (what they SHOULD look like):

$12.50
$14.60
$10.00
$4.59
$22.50
$19.19

Total
----------
$41.69

Is there a way to display with the right rounding other than rounding every individual cell with =Round(Cell, 2) ?

Howdy. Try the ROUNDUP function.

Microsoft's tutorial on Roundup
http://office.microsoft.com/assistan...%20number%20up