+ Reply to Thread
Results 1 to 10 of 10

Decimal convert into fraction

  1. 01-19-2015, 02:04 AM #1
    KTM450
    KTM450 is offline
    Registered User
    Join Date
    01-19-2015
    Location
    Portland Oregon
    MS-Off Ver
    2011
    Posts
    28

    Decimal convert into fraction

    I have a long spread sheet in which I merged 3 columns together in faction format. Using this formula =CONCATENATE(A2," ",B2," ",C2). The problem is its converting my factions into a decimal or number format. I've tried the format function in column D but it doesn't convert back to a fraction. Does anyone know how to convert column D back into a fraction format? Or better yet keep it from converting from a fraction to number to begin with with. Any solutions would be greatly appreciated.

    Thank you in advance

    Ex: Combined Columns A / B / C = D

    A = 11 1/8 B = x C = 31 1/2 D= 11.125 x 31.50

    Need to be: D= 11 1/8 x 31 1/2
    Reply With QuoteRegister To Reply
  2. 01-19-2015, 02:13 AM #2
    Debraj Roy
    Debraj Roy is offline
    Forum Expert Debraj Roy's Avatar
    Join Date
    09-27-2012
    Location
    New Delhi,India
    MS-Off Ver
    Excel 2013
    Posts
    1,469

    Re: Decimal convert into fraction

    Hi Ktm40,

    Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

    Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic

    In the meanwhile.. try to change the Number format to "# ?/?"
    Regards!
    =DEC2HEX(3563)

    If you like someone's answer, click the star to give them a reputation point for that answer...
    Reply With QuoteRegister To Reply
  3. 01-19-2015, 02:16 AM #3
    MarvinP
    MarvinP is offline
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,168

    Re: Decimal convert into fraction

    Hi KTM and welcome to the forum,

    Are you using the "Format Cells as Fraction" format? Read http://www.microsoft.com/education/e...fractions.aspx
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.
    Reply With QuoteRegister To Reply
  4. 01-19-2015, 02:21 AM #4
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,936

    Re: Decimal convert into fraction

    Using this formula =CONCATENATE(A2," ",B2," ",C2). The problem is its converting my factions into a decimal or number format.
    Any time you concat cells, you produce a text output. You need then format that "text to show what you want. Try this,,,
    =TEXT(A1,"# ?/??")&"x"&TEXT(C1,"# ?/??")
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    Reply With QuoteRegister To Reply
  5. 01-19-2015, 02:59 AM #5
    KTM450
    KTM450 is offline
    Registered User
    Join Date
    01-19-2015
    Location
    Portland Oregon
    MS-Off Ver
    2011
    Posts
    28

    Re: Decimal convert into fraction

    Thank you FDibbons solution worked.
    Reply With QuoteRegister To Reply
  6. 01-19-2015, 03:23 AM #6
    KTM450
    KTM450 is offline
    Registered User
    Join Date
    01-19-2015
    Location
    Portland Oregon
    MS-Off Ver
    2011
    Posts
    28

    Re: Decimal convert into fraction

    How do I a space and " to this formula? =TEXT(A1,"# ?/??")&"x"&TEXT(C1,"# ?/??")
    Ex:18 1/2x30 1/2 How do you make it look like this? 18 1/2" x 30 1/2"

    Thank you
    Reply With QuoteRegister To Reply
  7. 01-19-2015, 03:35 AM #7
    pjwhitfield
    pjwhitfield is offline
    Forum Expert
    Join Date
    10-09-2014
    Location
    Newcastle, England
    MS-Off Ver
    2003 & 2013
    Posts
    1,986

    Re: Decimal convert into fraction 

    Please Login or Register  to view this content.
    will add double quotes " (Chr(34) telling it to insert ASCII Char 34 which corresponds to ")


    therefore

    Please Login or Register  to view this content.
    If someone has helped you then please add to their Reputation
    Reply With QuoteRegister To Reply
  8. 01-19-2015, 04:15 AM #8
    KTM450
    KTM450 is offline
    Registered User
    Join Date
    01-19-2015
    Location
    Portland Oregon
    MS-Off Ver
    2011
    Posts
    28

    Re: Decimal convert into fraction

    No that didn't work I'm getting an error (#NAME?). See attachment spreadsheet.

    I trying to merge Column D & E into F.

    Thank you
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  9. 01-19-2015, 04:16 AM #9
    pjwhitfield
    pjwhitfield is offline
    Forum Expert
    Join Date
    10-09-2014
    Location
    Newcastle, England
    MS-Off Ver
    2003 & 2013
    Posts
    1,986

    Re: Decimal convert into fraction

    aaaarrrrrggghh sorry! getting VBA and Formulas confused

    Please Login or Register  to view this content.
    Reply With QuoteRegister To Reply
  10. 01-19-2015, 01:06 PM #10
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,936

    Re: Decimal convert into fraction

    Just add it into the formula, although I cheated a bit and used 2 ' instead of 1 "

    =TEXT(A1,"# ?/??")&"'' x"&TEXT(C1,"# ?/??")&"''"
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Convert fraction to decimal
    By sur4j in forum Excel General
    Replies: 10
    Last Post: 12-09-2019, 01:39 PM
  2. convert fractions to decimals and decimal to fraction
    By lnjr in forum Excel General
    Replies: 9
    Last Post: 12-19-2014, 07:29 PM
  3. i want this formaul convert fraction to decimal like ex(1/2) .5 i want it show like (0.5)
    By baig123 in forum Excel General
    Replies: 9
    Last Post: 06-18-2014, 05:41 AM
  4. Convert fraction to a decimal
    By Dillons Grandpa in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 02-24-2013, 12:49 PM
  5. [SOLVED] convert decimal to inch & fraction
    By davepatrob in forum Excel General
    Replies: 1
    Last Post: 12-31-2005, 01:10 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1