Exactly what is the "decrease decimal" function? If you mean the Cell
Formatting option of Number where you can specify the number of decimal
places, then changing the number of decimal places you see does *not* change
the underlying value in the cell... if it started as 6.46464 (no trailing
zeroes in the original value), it will still be 6.4646 after you change the
displayed format. So, 6.46464 displayed to 2 decimal places is 6.46 since
the number in the 3rd decimal place is 4.

--
Rick (MVP - Excel)


"BarbHerb" wrote in message
...
Why does Excel round correctly sometimes but not all the time when using
the
"decrease decimal" function?

Take for example the number - 6.464640
When you decrease the last digit you get - 6.46464
Excel rounds correctly, 0 is less than or equal to 5 so the 4 stays as is

When you decrease the next digit - 6.4646
Excel rounds correctly, 4 is less than or equal to 5 so the 6 stays as is

When you decrease the next digit - 6.465
Excel rounds correctly, 6 is greater than or equal to 5 so the 4 rounds to
5

When you decrease the next digit - 6.46
Excel does not round correctly, 5 is greater than or equal to 5 so the 6
should round to 7 but does not

Why is that please? Thanks! Barb