stop rounding

In a worksheet, my formula is multiplying an expense times an income factor
of .00000 with the result being rounded to 0.00

When I total the column, my answer is a total of .00000 rounded to 0.00, not
a total of all the 0.00

It is making a difference of dollars to my expenses, and I need the real
expense!

Thanks for any help you can provide.

I think what you are describing is that the result of the multiplication is
DISPLAYED with only 2 decimal places, but in fact is not rounded to 2 decimal
places. Those formulas should be

=ROUND(A1*<expensefactor>,2)

Or at Tools/Options you can change the setting to Precision as Displayed.

On Wed, 2 Feb 2005 11:15:04 -0800, "grianagh"
<grianagh@discussions.microsoft.com> wrote:

>In a worksheet, my formula is multiplying an expense times an income factor
>of .00000 with the result being rounded to 0.00
>
>When I total the column, my answer is a total of .00000 rounded to 0.00, not
>a total of all the 0.00
>
>It is making a difference of dollars to my expenses, and I need the real
>expense!
>
>Thanks for any help you can provide.

Thank you! It worked!

"Myrna Larson" wrote:

> I think what you are describing is that the result of the multiplication is
> DISPLAYED with only 2 decimal places, but in fact is not rounded to 2 decimal
> places. Those formulas should be
>
> =ROUND(A1*<expensefactor>,2)
>
> Or at Tools/Options you can change the setting to Precision as Displayed.
>
> On Wed, 2 Feb 2005 11:15:04 -0800, "grianagh"
> <grianagh@discussions.microsoft.com> wrote:
>
> >In a worksheet, my formula is multiplying an expense times an income factor
> >of .00000 with the result being rounded to 0.00
> >
> >When I total the column, my answer is a total of .00000 rounded to 0.00, not
> >a total of all the 0.00
> >
> >It is making a difference of dollars to my expenses, and I need the real
> >expense!
> >
> >Thanks for any help you can provide.
>
>