yah, that's right....

but if u wish to retain the real values whenever it is chained in a series
of other formulas, you better make a helper <row,column or cell
one for the purpose of SHOWING
and the other for the sake of other linked formulas....

maybe it's possible
--
*****
birds of the same feather flock together..



"RagDyer" wrote:

So ... now we know that you have a formula in the cell!

Simply wrap your formula with either Int() OR Trunc().

=INT(your formula)
=INT(SUM(A1:A100))

=TRUNC(your formula)
=TRUNC(A1*B1)


--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"kell~0" wrote in message
...
"Force all these cells" I don't want to go back and type in the interger,
because I'd loose the formula.

Kell~0

"Dave F" wrote:

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?