use

=RIGHT(A1,8)*-1

or to always return positive values

=ABS(RIGHT(A1,8))