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?

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?

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?

Odd. It doesn't round up on my machine. What version of XL are you using?
--
Brevity is the soul of wit.


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

I don't know where to find the version. I'd suppose that it is probably the
first XP office version ever!

"Dave F" wrote:

Odd. It doesn't round up on my machine. What version of XL are you using?
--
Brevity is the soul of wit.


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

One way
number is in A1

enter in B1
=INT(A1)

Greetings from New Zealand


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

It works, but is there a way to do this in the same cell?

"Bill Kuunders" wrote:

One way
number is in A1

enter in B1
=INT(A1)

Greetings from New Zealand


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

Isn't it getting dark in New Zealand?

"kell~0" wrote:

It works, but is there a way to do this in the same cell?

"Bill Kuunders" wrote:

One way
number is in A1

enter in B1
=INT(A1)

Greetings from New Zealand


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

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?

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?

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?

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?

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

try one other way,

you can generically show the number of decimals in a key stroke

=trunc("yourCells","yourDigitizerCell")

if you have a column of values, see help files

regards,
dribler
--
*****
birds of the same feather flock together..



"kell~0" wrote:

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

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?

=INT(A1)


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

=int(x)

EggHeadCafe.com - .NET Developer Portal of Choice
http://www.eggheadcafe.com