Thanks for all the help from which I've come up with this formula:

=VALUE(IF(C2<"",-TRIM(SUBSTITUTE(C2,CHAR(160),"")),TRIM(SUBSTITUTE( D2,CHAR(160),""))))

......which seems to do the trick.

Thanks again