Function for + and - numbers
 

I ran a query that dumps into Excel, but their format shows + and/or - with
the number in the cell. I want to add the cell content, but ignore the + or
-................can I do this and if yes............what formula do I use?

Function for + and - numbers
 

=B1+ABS(A1)
--
David Biddulph

"slschram" wrote in message
...
I ran a query that dumps into Excel, but their format shows + and/or - with
the number in the cell. I want to add the cell content, but ignore the +
or
-................can I do this and if yes............what formula do I
use?

Function for + and - numbers
 

Hi,

instead of =SUM(A1:A10)

use =SUM(ABS(A1:A10))

Enter this last formula by pressing Shift Ctrl Enter instead of Enter. Or

=SUMPRODUCT(ABS(A1:A10)) this doesn't need Shift Ctrl Enter

Cheers,
Shane Devenshire

Function for + and - numbers
 

Thank you so much - worked beautifully!!

"ShaneDevenshire" wrote:

Hi,

instead of =SUM(A1:A10)

use =SUM(ABS(A1:A10))

Enter this last formula by pressing Shift Ctrl Enter instead of Enter. Or

=SUMPRODUCT(ABS(A1:A10)) this doesn't need Shift Ctrl Enter

Cheers,
Shane Devenshire

Function for + and - numbers
 

Thank you! I appreciate you taking the time!


"David Biddulph" wrote:

=B1+ABS(A1)
--
David Biddulph

"slschram" wrote in message
...
I ran a query that dumps into Excel, but their format shows + and/or - with
the number in the cell. I want to add the cell content, but ignore the +
or
-................can I do this and if yes............what formula do I
use?