=LEFT(A1,FIND("'",A1)-2)+RIGHT(A1,LEN(A1)-FIND("'",A1)-1)/32
--
David Biddulph

"aupeter" <u50243@uwe wrote in message news:92dd458bb78f2@uwe...
I am new to the forum, so some help would be appreciated.

I have data in the form of 132 ' 30 which represents 132 30/32.

If someone could show me how to convert into the /32, I would appreciate
it.,.


Thanks

AU