Excel Conversion help

C

Covert

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
 
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
 
You must log in or register to reply here.
Back
Top