<Tools<Options
"Calculation" tab
Click "Precision as displayed"

Be careful, though, as you will lose all precision past what you display and
won't be able to get it back.
--
Regards,
Dave


"ernie" wrote:

my numbers do not round up... lets say i have dfferent cells get values based
on different calculation.. ex: A1 get its value from B1. B1=2.7169. when i
format A1 to 2 decimal places it show 2.72. now if i multiply A1 by 3 in
another cell, instead of showing 8.16 (2.72*3), it shows 8.15 (2.7169*3). i
need the cells to calculate based on whats in it. how to i get it to
calculate with 2.72 instead of 2.7169???

thanks in advance.
--
help a friend help you