Number problems

[KLU]

I have data that gets transfered into excel as (120^11.75)
this is a bond quote which is 120 11.75/32
I can't get excel to change into this latter format or divide a numerator that has a decimal in it.
anyone have a suggestion besides a manual entering of the data

 

[shg]

Maybe =DOLLARDE(SUBSTITUTE(SUBSTITUTE(A1, ".", ""), "^", "."), 32)