Excel Conversion help

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

  1. 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.


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


  3. You can use the following equation:

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


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