Excel Conversion help

Could anyone help with an Excel conversion. I would like to convert the Treasury data I have exported from e-signal, but the cells won't calculate in the format they are in.

112'16

should be

112 16/32

What format conversion should I use to convert a large number of cells, instead of converting them one at a time.
Thanks

 

I've had very good results posting questions here.........

http://www.excelforum.com/

 

You can use the following equation:
=LEFT(A1,3)+RIGHT(A1,2)/32

The only problem is that not all values will be XXX'XX. You can also have values like
90'5 (90 5/32)

I think the following equation should work:
=LEFT(A1,FIND("'",A1)-1)+RIGHT(A1,LEN(A1)-FIND("'",A1))/32

 

Arnie and Newbunch-
Many thanks for the help; very helpful.