| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| does an IF function only look up numbers & not text? | Excel Discussion (Misc queries) | |||
| Random numbers function | Excel Worksheet Functions | |||
| numbers to text function | Excel Worksheet Functions | |||
| Words > Numbers (i.e. Vanity Phone Numbers) function | Excel Worksheet Functions | |||
| words and numbers in an IF function | Excel Discussion (Misc queries) | |||
Linear Mode
