software

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 quot;0quot;.

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

Helllp??
--
THX cs

Using if(ABS(b1)=0,... (or if(--b1=0,...) worked.

However.. I still don't understand why it would export as a negative 0 when
it should already be absolute zero.

(By quot;exportquot; I mean copy and paste the data from and Access query into Excel
to perform further calculations.)

p.s. quot;4/2quot; is a simple example of the formula I'm using for the purpose of
explanation here.
--
THX csquot;Slothquot; wrote:

gt; I don't know how to fix you import/export problem but you should probably be
gt; able to change your formula to this
gt;
gt; =IF(--b1=0,0,4/2)
gt;
gt; PS-why do you use 4/2 instead 2?
gt;
gt; quot;Cydneyquot; wrote:
gt;
gt; gt; I've come across an issue I can't seem to understand or resolve. Would
gt; gt; appreciate it if someone could help me out.
gt; gt;
gt; gt; I'm getting financial data from an ODBC source and then performing a simple
gt; gt; subtraction calculation of two fields. With the format set at 15 decimals,
gt; gt; the 2 numbers are the same. When I subtract one from the other, in Access it
gt; gt; returns quot;0quot;.
gt; gt;
gt; gt; That's all just fine. However, when I copy that query result into Excel, the
gt; gt; number is quot;-0quot;. Why is that? It prevents me from creating a formula with an
gt; gt; IF statement that something like quot; =IF(b1=0,0,4/2) quot;. I need the number to
gt; gt; return 0, not negative 0.
gt; gt;
gt; gt; Helllp??
gt; gt; --
gt; gt; THX cs

For some reason it is importing it as text. You can force a change by
copying a blank cell and then using quot;paste specialquot; on the cells in question
(simply select all your data). Select add and click ok. All -0's should be
converted to the number 0.

quot;Cydneyquot; wrote:

gt; Using if(ABS(b1)=0,... (or if(--b1=0,...) worked.
gt;
gt; However.. I still don't understand why it would export as a negative 0 when
gt; it should already be absolute zero.
gt;
gt; (By quot;exportquot; I mean copy and paste the data from and Access query into Excel
gt; to perform further calculations.)
gt;
gt; p.s. quot;4/2quot; is a simple example of the formula I'm using for the purpose of
gt; explanation here.
gt; --
gt; THX cs
gt;
gt;
gt; quot;Slothquot; wrote:
gt;
gt; gt; I don't know how to fix you import/export problem but you should probably be
gt; gt; able to change your formula to this
gt; gt;
gt; gt; =IF(--b1=0,0,4/2)
gt; gt;
gt; gt; PS-why do you use 4/2 instead 2?
gt; gt;
gt; gt; quot;Cydneyquot; wrote:
gt; gt;
gt; gt; gt; I've come across an issue I can't seem to understand or resolve. Would
gt; gt; gt; appreciate it if someone could help me out.
gt; gt; gt;
gt; gt; gt; I'm getting financial data from an ODBC source and then performing a simple
gt; gt; gt; subtraction calculation of two fields. With the format set at 15 decimals,
gt; gt; gt; the 2 numbers are the same. When I subtract one from the other, in Access it
gt; gt; gt; returns quot;0quot;.
gt; gt; gt;
gt; gt; gt; That's all just fine. However, when I copy that query result into Excel, the
gt; gt; gt; number is quot;-0quot;. Why is that? It prevents me from creating a formula with an
gt; gt; gt; IF statement that something like quot; =IF(b1=0,0,4/2) quot;. I need the number to
gt; gt; gt; return 0, not negative 0.
gt; gt; gt;
gt; gt; gt; Helllp??
gt; gt; gt; --
gt; gt; gt; THX cs