| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
No rounding up or down
Hi,
Is there anyway to disable excel from either rounding up or down, just to keep the number as is? for example, if I have 160.19423, I want to make it 160.19 and not 160.20 Any suggestions? Thanks! Carol |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
No rounding up or down
Look in help for TRUNC assuming you want a formula, with 160.19423 in A1
=TRUNC(A1,2) will return what you want -- Regards, Peo Sjoblom http://nwexcelsolutions.com "QPapillon" wrote in message ... Hi, Is there anyway to disable excel from either rounding up or down, just to keep the number as is? for example, if I have 160.19423, I want to make it 160.19 and not 160.20 Any suggestions? Thanks! Carol |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Rounding or not rounding | Excel Worksheet Functions | |||
| Unwanted rounding of large number | Excel Worksheet Functions | |||
| Rounding numbers to the nearest 5 or 0 | Excel Worksheet Functions | |||
| Percentage rounding error in charts | Excel Discussion (Misc queries) | |||
| Banker's Rounding - need help! | Excel Discussion (Misc queries) | |||
Linear Mode
