Negative Zero (-0) Exporting to Excel
 

I don't know how to fix you import/export problem but you should probably be
able to change your formula to this

=IF(--b1=0,0,4/2)

PS-why do you use 4/2 instead 2?

"Cydney" wrote:

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??
--
THX cs