Thanks Roger,much appreciated.

Doug

"Roger Govier" wrote:

Hi Doug

On the extracted values use
=--(RIGHT(A1)&LEFT(A1,LEN(A1)-1))

--
Regards

Roger Govier


"Doug" wrote in message
...

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