Don't Round...

[Michael Miazga]

How can I make Excel NOT round the numbers. For example I have a cell
that has a formula with a result of 4.3564, the cell is formatted as a
number with 2 decimals so that it displays 4.36. I want the cell to
display 4.35, don't round the number.

 

[PCLIVE]

Use a Custom format of:

0.00

HTH,
Paul

 

[Michael Miazga]

It still rounds!?

Use a Custom format of:

0.00

HTH,
Paul

 

[Peo Sjoblom]

Try

=TRUNC(C3,2)


replace C3 with the formula that returns 4.3564 and format as general or
number

 

[joeu2004]

How can I make Excel NOT round the numbers. For example I have a cell
that has a formula with a result of 4.3564, the cell is formatted as a
number with 2 decimals so that it displays 4.36. I want the cell to
display 4.35, don't round the number.

=trunc(formula, 2)

But read the TRUNC help page for an explanation of TRUNC() v. INT().

 

[Michael Miazga]

Thank you!

 

[ed]

How can I make Excel NOT round the numbers. For example I have a cell
that has a formula with a result of 4.3564, the cell is formatted as a
number with 2 decimals so that it displays 4.36. I want the cell to
display 4.35, don't round the number.

ROUNDDOWN(number,num_digits)

ed

 

[Bill Sharpe]

How can I make Excel NOT round the numbers. For example I have a cell
that has a formula with a result of 4.3564, the cell is formatted as a
number with 2 decimals so that it displays 4.36. I want the cell to
display 4.35, don't round the number.

I presume that you're not doing anything else with the number except
displaying it. If you are making further calculations with the truncated
number you may be introducing errors that you won't be aware of.

Bill