View Single Post
  #2   Report Post  
Gordon
 
Posts: n/a
Default

Sean wrote:
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


Set it to 4 places of decimal - do you *need* 25 places?