A
AR
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!
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!