The =INT(MyFormula) is working. However, when I enter it it affects the
formula in the next cell and the next cell all the way down the row.

I'm sorry I wasn't clear when I asked yesterday.

"Gord Dibben" wrote:

Good point Peo.

Gord

On Tue, 09 Jan 2007 13:44:41 -0800, Peo Sjoblom wrote:

Actually if the OP needs to do this it is better to use TRUNC since
INT will round down to the nearest integer, that means a negative value
like -123,478.99 will return -123,479 with INT and -123,478 with TRUNC


Regards,

Peo Sjoblom

Gord Dibben wrote:
You could use a helper column and =INT(cellref) which will return only the
number without decimal rounding up.

This will affect the value of the number however and may not be what you desire.

104,978.6849 will become 104,978.0000 which you then format for no DP


Gord Dibben MS Excel MVP

On Tue, 9 Jan 2007 11:44:00 -0800, kell~0
wrote:

When I use that button, the whole number is rounded up. So, it goes like this:
$104,978.6849
$104,978.685
$104,978.69
$104,978.7
$104,979

It needs to show $104,978.

Any other trick in your bag?

"Dave F" wrote:

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
--
Brevity is the soul of wit.


"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?