One way:

=LEFT(A1,FIND("'", A1)-1)/100 & TEXT(RIGHT(A1, 1)/8," ?/?")

In article ,
"Kaci" wrote:

How to Change a number from ex. 565'6 to 5.65 3/4