I think you'll find that the button has exactly the same effect as changing
the number of decimal places in Format/ Cells/ Number.

Note also that it won't behave any differently before the decimal point from
after. If you have 1234.4448 it would change to 1234.445 but then to
1234.44.

The reason you saw it rounding up the numbers after the decimal point is
that each digit was greater than 5, until you got to 1234.5
--
David Biddulph

"Epinn" wrote in message
...
Thanks David. I was aware of what you said except "only affects what is
displayed." I was surprised because it rounded up the digits to the *right*
of the decimal and so I expected the same to the *left* of the decimal.

I was watching the following unfold and I saw the second last one was
1234.5.

1234.4567--1234.457--1234.46--1234.5--1234

I'll accept the fact that the button behaves differently from ROUND( ).
Thanks again for highlighting the nature of the button.

Epinn

"David Biddulph" wrote in message
...
Epinn,

The reason that it didn't round up in scenario 1 was that you are not
rounding from .5, but from .4567. Remember that the cell still contains the
full number, and the rounding (by cell format as controlled by the button)
only affects what is displayed. [You can go back to more decimal places by
the other button with the reverse function.]

If you want to change the value in the cell, use the ROUND() function.
--
David Biddulph

"Epinn" wrote in message
...
Yes, I also got 104,979 i.e. it was rounded.

However, I discovered something unexpected using that button. In
mathematics, I am used to .5 being rounded up. With the button, it is
inconsistent - sometimes it does and sometimes it doesn't. Am I missing
something? I use V. 2003.

Scenario 1

1234.4567--1234.457--1234.46--1234.5--1234

..5 wasn't rounded up??

Scenario 2

1234.5000 (format = 4 decimal places) then use the button.

Result = 1235

I don't understand this inconsistency and I don't feel comfortable using the
button. Well, another anomaly of Excel?

Appreciate any clarification or guidance.

Epinn

"Bernard Liengme" wrote in message
...
Well is should round. Are you sure you have $104,978.6849 ?
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Dave F" wrote in message
...
Well, it doesn't round up on my machine. Not sure why.
--
Brevity is the soul of wit.


"David Biddulph" wrote:

Wouldn't that give $104,979, Dave?

I don't know what the OP meant by "We do not want to force all of these
cells", but I think he needs =INT(A1).
--
David Biddulph

"Dave F" wrote in message
...
The formatting toolbar has a button that allows you to decrease the
number
of
decimals. It looks like an arrow pointing to the right with a bunch of
zeroes on it...

Dave

"kell~0" wrote:

I need to show only the whole number, not the number resulting by
removing
the decimals. We do not want to force all of these cells.

So, if the number is $104,978.6849 it needs to show $104,978, not
$104,979

How do I do this?