I need to format a numeric cell to 8 without rounding. Is this possible in
excel?

Do you mean to 8 decimal places? Rounding will occur on the least
significant digit, unless you truncate the value.

Pete

On Jan 15, 3:51*pm, dukhook wrote:
I need to format a numeric cell to 8 without rounding. *Is this possible in
excel?

yes, I have a series of numbers for example:
5.648295137. I want to cut at 3 without rounding it to 4. I don't know how
to format cell to do this.

"Pete_UK" wrote:

Do you mean to 8 decimal places? Rounding will occur on the least
significant digit, unless you truncate the value.

Pete

On Jan 15, 3:51 pm, dukhook wrote:
I need to format a numeric cell to 8 without rounding. Is this possible in
excel?

One way:

=INT(A16*100000000)/100000000

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"dukhook" wrote in message
...
yes, I have a series of numbers for example:
5.648295137. I want to cut at 3 without rounding it to 4. I don't know
how
to format cell to do this.

"Pete_UK" wrote:

Do you mean to 8 decimal places? Rounding will occur on the least
significant digit, unless you truncate the value.

Pete

On Jan 15, 3:51 pm, dukhook wrote:
I need to format a numeric cell to 8 without rounding. Is this
possible in
excel?

If you are saying you wish a number to display as the nearest integer, but
retain the number unchanged for further calculation, then Format/ Cells/
Number:
Number: 0 decimal places.
--
David Biddulph

"dukhook" wrote in message
...
I need to format a numeric cell to 8 without rounding. Is this possible in
excel?

Not really. I need a number with more than 8 decimal places for example 10
or 11 to be chopped after 8 decimals without 9th dcimal place being used for
rounding. My number for calculations would then become 8 decimal number.

"David Biddulph" wrote:

If you are saying you wish a number to display as the nearest integer, but
retain the number unchanged for further calculation, then Format/ Cells/
Number:
Number: 0 decimal places.
--
David Biddulph

"dukhook" wrote in message
...
I need to format a numeric cell to 8 without rounding. Is this possible in
excel?

That is what Sandy has given you.

Pete

On Jan 15, 4:30*pm, dukhook wrote:
Not really. *I need a number with more than 8 decimal places for example 10
or 11 to be chopped after 8 decimals without 9th dcimal place being used for
rounding. *My number for calculations would then become 8 decimal number..



"David Biddulph" wrote:
If you are saying you wish a number to display as the nearest integer, but
retain the number unchanged for further calculation, then Format/ Cells/
Number:
Number: *0 decimal places.
--
David Biddulph

"dukhook" wrote in message
...
I need to format a numeric cell to 8 without rounding. *Is this possible in
excel?- Hide quoted text -

- Show quoted text -

=ROUNDDOWN(A2,8)
--
David Biddulph

"dukhook" wrote in message
...
Not really. I need a number with more than 8 decimal places for example
10
or 11 to be chopped after 8 decimals without 9th dcimal place being used
for
rounding. My number for calculations would then become 8 decimal number.

"David Biddulph" wrote:

If you are saying you wish a number to display as the nearest integer,
but
retain the number unchanged for further calculation, then Format/ Cells/
Number:
Number: 0 decimal places.
--
David Biddulph

"dukhook" wrote in message
...
I need to format a numeric cell to 8 without rounding. Is this possible
in
excel?