Question: I have a row of numbers that I need to sum. When I try to sum I get zero (0) when I know there should be a value. The numbers all have a (-) negative sign at the end and an extra space at the end.

How do I convert this to an actual number, remove the extra space to be able to sum up? Do I need to remove the (-) negative sign at the end and move to the front?

Here's the data I'm working with.

[![enter image description here](https://i.stack.imgur.com/hKxqC.jpg)](https://i.stack.imgur.com/hKxqC.jpg)

Answer: 
If your numbers have just `,` `.` `-` then all you need is: 

```
=VALUE(SUBSTITUTE(A1,"-",""))

```

Otherwise you need one `SUBSTITUTE(A1,"something","")` for every non digit character (except for `,` `.`), and then to wrap it all in `=VALUE(someformulas)`.

If you want to move the minus to the front (but check first if you do have a `-` to move) then add the following before all of the `SUBSTITUTE`subformulas:

`IF(ISNUMBER(FIND("-",A1)),"-","")&`

Final product should look something like this:

`=VALUE(IF(ISNUMBER(FIND("-",A1)),"-","")&SUBSTITUTE(A1,"something",""))`
You can just do a Find & Replace for '- '.

Then use -SUM(....) to sum and switch to negative.