You said you used my formula "on the question as attached"; but I'm looking at question-1.xls, and it doesn't have my formula in there. It doesn't have any formula. It looks like the same workbook you attached the first time. So I cannot see what you tried, and why it didn't work.

However, I think I know why it didn't work. Remember, I said below that my solution would work "if your desire is simply to interpret '3 1/2' and return 3.5 (for example)". The numbers in blue are the powers, ie "3 1/2", "1/2" etc. But the contents of a whole cell are the base and the power together; the cell contains "5 3 1/2", and you need a method to separate the "3 1/2" from the "5" before my formulas can work.

Do you know how to separate the two parts of the number? Post question-1.xls again, but this time include in it the formulas you've tried. It doesn't matter that they don't work; by looking at what you tried, even if it's wrong, I will probably be able to see why you don't understand the problem, and explain it to you better.