Function for + and - numbers

[slschram]

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?

 

[David Biddulph]

=B1+ABS(A1)

 

[ShaneDevenshire]

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

 

[slschram]

Thank you so much - worked beautifully!!

 

[slschram]

Thank you! I appreciate you taking the time!

=B1+ABS(A1)