But that only works if the fraction has a single digit on top and on the bottom. It will fall down for something like 15/16.
A more generic solution (again assuming that the value is in cell A5) would be:
=LEFT(A5,FIND("/",A5)-1)/RIGHT(A5,LEN(A5)-FIND("/",A5))
Gill, how are your getting your...