Microsoft Excel 2003

my format is multiplying cell by 0.245 the system automatically rounds up to
the
nearest unit (because i am using currency)
When l total the whole column it adds by the original three digit and not
the rounded up figure. Which means by totals are incorrect