Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

convert decmials to fractions

Discussion in 'Information Technology' started by Brett, Jul 28, 2006.

  1. Brett

    Brett
    Expand Collapse
    Guest

    When i import my bill of materials into excel. I have in. on the end of the
    decmials. I am converting and it will not turn to a fraction. Example: .750
    in. will not convert but .750 will .The other program default the in. I cant
    get rid of it . thanks Brett
     
  2. Loading...

    Similar Threads Forum Date
    Sikhconvert Joins Sikh Philosophy Network! New SPN'ers Aug 28, 2016
    Jehovah's Witnesses Are Out And Converting! Blogs Jul 31, 2016
    Islam Ishna Has Converted To Islam Interfaith Dialogues Apr 1, 2016
    A Christian Missionary tried to convert me. Blogs Oct 22, 2015
    "Convert's Corner" - Ideas for Retitle? Convert's Corner Oct 21, 2015

  3. Michael H

    Michael H
    Expand Collapse
    Guest

    This is a newsgroup for Access, the database program that is part
    of MS Office Professional. Your question does not seem to be related to
    this newsgroup.

    However, assuming your string is in cell A1, and that there is always a
    space between the number and the text, you might try this:
    =VALUE(LEFT(A1,FIND(" ",A1,1)))

    If you have trouble with this, please post your question to an Excel group.

    -Michael


    "Brett" wrote:

    > When i import my bill of materials into excel. I have in. on the end of the
    > decmials. I am converting and it will not turn to a fraction. Example: .750
    > in. will not convert but .750 will .The other program default the in. I cant
    > get rid of it . thanks Brett
     

Share This Page