Change the MID to reflect the situation with your "-" signs

e.g using Column D

=MID(D3,4,3)*1

starting at 4th character in the text field