Negative Zero (-0) in export to Excel

[Cydney]

I've come across an issue I can't seem to understand or resolve. Would
appreciate it if someone could help me out.

I'm getting financial data from an ODBC source and then performing a simple
subtraction calculation of two fields. With the format set at 15 decimals,
the 2 numbers are the same. When I subtract one from the other, in Access it
returns "0".

That's all just fine. However, when I copy that query result into Excel, the
number is "-0". Why is that? It prevents me from creating a formula with an
IF statement that something like " =IF(b1=0,0,4/2) ". I need the number to
return 0, not negative 0.

Helllp??

 

[xRoachx]

What about the 2nd? I tested both on my end and they each worked.