[KT]

I have cells that have numbers that are 3 and 4 digits beyond the decimal
point . I need them to have 2 digits beyond the decimal point. So I used the
=ROUND(cell,2) to round to 2 digits beyond the decimal. However, the sum of
my original column and the sum of my new column are different from each
other. They should be the same.

How do I truncate the extra digits beyond the decimal point without changing
the sum?

[Gary''s Student]

If you use the ROUND() function, you are really changing the values that are
being tallied. To get the SUM to be the same, don't use ROUND; instead
format the cells to:

Format Cells... Number Number decimal places 2
--
Gary''s Student - gsnu200792

[edvwvw via OfficeKB.com]

Use TRUNC(A1,2) should give you the result that you want

edvwvw

KT wrote:
I have cells that have numbers that are 3 and 4 digits beyond the decimal
point . I need them to have 2 digits beyond the decimal point. So I used the
=ROUND(cell,2) to round to 2 digits beyond the decimal. However, the sum of
my original column and the sum of my new column are different from each
other. They should be the same.

How do I truncate the extra digits beyond the decimal point without changing
the sum?

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200806/1

[David Biddulph[_2_]]

If you don't want to change the underlying value, but want to display with 2
decimal places, use Format Cells/ Number/ 2 places instead of ROUND.
If you use ROUND, it changes the numbers, and hence the total is likely to
change.
--
David Biddulph

"KT" wrote in message
...
I have cells that have numbers that are 3 and 4 digits beyond the decimal
point . I need them to have 2 digits beyond the decimal point. So I used
the
=ROUND(cell,2) to round to 2 digits beyond the decimal. However, the sum
of
my original column and the sum of my new column are different from each
other. They should be the same.

How do I truncate the extra digits beyond the decimal point without
changing
the sum?