Excel automatically Rounds values ending in 5 away from 0. For example, if you show (or use the ROUND function) on 0.005 and -0.005 to 2 decimals, you'll get 0.01 and -0.01 respectively. So the first is rounded up and the second rounded down. To be consistant, the negative value at -0.005 should round to 0.00. Is there an easy way to get this accomplished when you are uncertain as to whether your value will be negative or positive to begin with? This will cover huge amounts of data in huge amounts of workbooks so I'm trying to stay away from complex formulas, user functions or macros. Thanks

ChemistB