You can convert characters to numbers by using the TO_NUMBER() function as shown in the following examples:

SELECT TO_NUMBER('4123.4570') FROM DUAL

4123.457

SELECT TO_NUMBER(' $4,123.46','$9,999,999.99') FROM DUAL

4123.46

SELECT TO_NUMBER(' -4.12E+03') FROM DUAL

-4120