View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph David Biddulph is offline
external usenet poster
 
Posts: 620
Default 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?