I have data that looks like this

4.23-

100.23-
10121.23-

I need make this a number. so that it can be used in formulas
I have tried to multiple it by 1 to convert it to a number, but this
does not work.
I thinking i have to write a formula that will extract all data left of
the - sign.
What would that formula be.


Thanks.