| 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? |
| 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) | |||
Threaded Mode
