How to stop excel from rounding ?

M

majestikwun

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?
 
M

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
 
C

Carlo

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
 
B

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top