+ Reply to Thread
Results 1 to 4 of 4

Fraction is read as decimal when text is combined in new cell

  1. #1
    Registered User
    Join Date
    10-27-2017
    Location
    Coulterville, CA
    MS-Off Ver
    2013
    Posts
    2

    Fraction is read as decimal when text is combined in new cell

    I am using the following function to pull cell content from two boxes and combine them into one box: =B13&" x "&B14. The problem I run into is that even though the number in cell B13 for example is 11 1/4, when it pulls it into the new cell it changes it to a decimal--11.25 even though the formatting for the new cell is set for fractions instead of decimals.
    Attached Images Attached Images

  2. #2
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: Fraction is read as decimal when text is combined in new cell

    You need to use the TEXT worksheet function to preserve the formatting.
    If posting code please use code tags, see here.

  3. #3
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2016
    Posts
    5,891

    Re: Fraction is read as decimal when text is combined in new cell

    Try this ...

    =TEXT(B9,"0 #/#")&" x "&TEXT(B10,"0 #/#")

  4. #4
    Registered User
    Join Date
    10-27-2017
    Location
    Coulterville, CA
    MS-Off Ver
    2013
    Posts
    2

    Re: Fraction is read as decimal when text is combined in new cell

    Phuocam, Thank you so much for the formula. Worked perfectly!!! And thank you as well Norie for giving me the name of this particular type of formula. Every little bit of knowledge gets me a little further down the road.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Problems converting fraction as a text cell to a decimal
    By KTENHAKEN in forum Excel General
    Replies: 4
    Last Post: 12-09-2019, 01:38 PM
  2. [SOLVED] Display only 1 decimal place but when combined with text
    By Leonthefixer in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-23-2015, 06:58 AM
  3. Converting Decimal to Fraction Text VBA
    By vbalearnerSF in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-27-2014, 02:38 PM
  4. Replies: 10
    Last Post: 06-11-2013, 06:11 PM
  5. [SOLVED] " / " Changing Decimal number format to Fraction on Protected Cell
    By laudie in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 11-14-2005, 10:15 PM
  6. " / " Changing Decimal number format to Fraction on Protected Cell
    By laudie in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 11-14-2005, 09:15 PM
  7. How do I change a text fraction. eg 1 1/2 into a decimal number, .
    By antac in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-28-2005, 01:06 PM

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1