View Single Post
  #3   Report Post  
Norman Jones
 
Posts: n/a
Default

Hi Sean,

See chip Pearson's page on rounding an precision in Excel at:

http://www.cpearson.com/excel/rounding.htm


---
Regards,
Norman



"Sean" wrote in message
...
Actually I found this problem recently and don't know why this could
happen.
I did simple minus calculation of these two values: (-0.365)-(-0.3575)
and excel shows -0.0075000000000000100000000.
It is not exactly -0.0075.
Do I need to change some settings or ....?

Thank you