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

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

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

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

Try this ...

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

4. ## 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.

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

#### 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