Hi I have a question that I need help on. In Excel I have a column with
numbers that have 2 digits beyond the decimal point. At the bottom of the
column I have the grand total shown. I used AutoSum to give me this number.
It's off by a penny. Meaning the grand total is higher by one penny. I need
it to display the correct total.

I have tried using this with no luck:
Precision As Displayed

Is there a way to simply force Excel to limit all numbers to 2 digits passed
the decimal. Not only showing only 2, but also only to calculate only two and
NO rounding. This seems simple enough to me, but then we are talking
logically. BTW I have gone to Format, Cells, Number and seen that it is
showing only 2. However, I have read it still reads 15 numbers passed the
decimal. Thanks!

Hi,
some of your values has more than 2 digits, that is why your autosum is off
a penny, one solution is, assuming your numbers are in column A enter in a
different column

=round(a1,2)

then replace your number with the above information and the autosum will work

if this helps please click yes, thank you

"AR" wrote:

> Hi I have a question that I need help on. In Excel I have a column with
> numbers that have 2 digits beyond the decimal point. At the bottom of the
> column I have the grand total shown. I used AutoSum to give me this number.
> It's off by a penny. Meaning the grand total is higher by one penny. I need
> it to display the correct total.
>
> I have tried using this with no luck:
> Precision As Displayed
>
> Is there a way to simply force Excel to limit all numbers to 2 digits passed
> the decimal. Not only showing only 2, but also only to calculate only two and
> NO rounding. This seems simple enough to me, but then we are talking
> logically. BTW I have gone to Format, Cells, Number and seen that it is
> showing only 2. However, I have read it still reads 15 numbers passed the
> decimal. Thanks!
>
>