I am trying to take out the number value from cells A1 to A3 and return them
in a value that i can sum in B4.i can take the text out by using the formula
below,my problem is that the + and - figures appear at the end of the number
and so cannot be "sumed".Can they be returned in front of the number or
return as a +or- figure so i can sum them?
Any help appreciated.

A B
1 Tot Val: 5.70- 5.70-
2 Tot Val: 6.64+ 6.64+
3 Tot Val: .00+ .00+

=SUBSTITUTE(A1,"Tot Val:","")

Doug M