Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Round up down or anywhere
I have to fill in a form for the dreaded tax office. Now this form needs to
be correct only to 2 decimal places, therefore discarding any number after that without rounding the thrid decimal place up. Is there are format to use on the whole work book? Also any calculations done with that figure should only use those 2 decimal places but Excell keeps using the whole figure, can this be stopped also? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Round up | Excel Discussion (Misc queries) | |||
How do I ROUND() round off decimals of a column dataset? | Excel Worksheet Functions | |||
how do I round up? | Excel Worksheet Functions | |||
How can I round UP to to the next ,50? | Excel Worksheet Functions | |||
How can I round UP to to the next ,50? E.g. 2,3 should become 2,5. | Excel Worksheet Functions |