How to stop excel from rounding ?

[Guest]

Say I have a number such as 0.002356449. I want it to display 0.00235644 not
0.00235645. I dont want the numbers to stop rounding up. Or say the end
result of my formula is $4.889 and I only want to display $4.88 without it
rounding up to $4.89. Please Help!!!!! It also seems to round up everytime I
shorten the column width to display the numbers I want. How do I stop it from
doing that?

 

[MartinW]

Hi majestikwun,

Rounding up is the mathematically correct way to do it.
You can use ROUNDOWN as a workaround.

i.e.
=ROUNDDOWN(A1,8) for your first example
=ROUNDDOWN(A1,2) for your second example

HTH
Martin

 

[Guest]

hi majestikwun

it's only how excel displays the numbers, if you change the width of a
column,
excel changes the quantity of numbers it displays. You can format the cell, so
that it always shows you an amount of numbers.
If you want excel to not round, you would need to use the Floor-function!

Cheers Carlo

 

[Bob Phillips]

Use formatting, so that the result looks as you want, but the value remains
intact, such as

$#,##0.00;-$#,##0.00

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)