I am getting wrong answers to simple math problems in excel 2010. Possibly related to rounding. How can I fix this?
Example: Calculator figures .77*32 as 24.64, Excel figures it as 24.60
I am getting wrong answers to simple math problems in excel 2010. Possibly related to rounding. How can I fix this? Example: Calculator figures .77*32 as 24.64, Excel figures it as 24.60 


excel work with 8 byte numbers bydefault and have 15 digit presision. i was unable to duplicate your example in office 2010 for mac and windows version. Most likely that you are looking at formatted numbers. 24.64/32=0.76865. Is your 0.77 not perhaps formatted already? 

