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?