Excel Conversion help

Discussion in 'Trading Software' started by Covert, Oct 3, 2006.

  1. Covert

    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
     
  2. Arnie

    Arnie

  3. 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
     
  4. Covert

    Covert

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