Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to stop excel from rounding ?
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to stop excel from rounding ?
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to stop excel from rounding ?
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 "majestikwun" wrote: 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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to stop excel from rounding ?
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) "majestikwun" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I stop excel from rounding numbers? | Excel Discussion (Misc queries) | |||
How can I stop excel from automatically making hyperlinks | Excel Discussion (Misc queries) | |||
stop rounding up in a colum that contains decimals in excel | Excel Worksheet Functions | |||
stop Excel from rounding 22/32 to 11/16 | Excel Discussion (Misc queries) | |||
How to stop Excel from changing the cell properties? | Excel Discussion (Misc queries) |