Don't Round...
 

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.

Don't Round...
 

Use a Custom format of:

0.00

HTH,
Paul

"Michael Miazga" wrote in message
...
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.

Don't Round...
 

It still rounds!?

PCLIVE wrote:
Use a Custom format of:

0.00

HTH,
Paul

"Michael Miazga" wrote in message
...
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.

Don't Round...
 

Try

=TRUNC(C3,2)


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



--
Regards,

Peo Sjoblom



"Michael Miazga" wrote in message
...
It still rounds!?

PCLIVE wrote:
Use a Custom format of:

0.00

HTH,
Paul

"Michael Miazga" wrote in message
...
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.

Don't Round...
 

On Jul 20, 11:32 am, Michael Miazga wrote:
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().

Don't Round...
 

Thank you!

Peo Sjoblom wrote:
Try

=TRUNC(C3,2)


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

Don't Round...
 

On Jul 20, 1:32 pm, Michael Miazga wrote:
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

Don't Round...
 

Michael Miazga wrote:
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