Format Cell w/out rounding

[dukhook]

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

 

[Pete_UK]

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

Pete

 

[dukhook]

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.

 

[David Biddulph]

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.

 

[Sandy Mann]

One way:

=INT(A16*100000000)/100000000

--
HTH

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

[email protected]
Replace @mailinator.com with @tiscali.co.uk

 

[dukhook]

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.

 

[Pete_UK]

That is what Sandy has given you.

Pete

Not really.  I need a number with more than 8 decimal places for example10
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..






- Show quoted text -

 

[David Biddulph]

=ROUNDDOWN(A2,8)
--
David Biddulph

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.