converting decimals to fractions

using a formula to combine multiple cells. one of the cells has a fraction 5
1/4 . the results of the formula from the combined cells is converting the 5
1/4 to 5.25 how do I get the result of the formula to retain the 5 1/4
fraction. I have tried formating the cell but that dosen't seem to work.
Using excel 2002

Hi Jason

If I enter 5 1/4 in A1, and 2 in B1 in C1=A1+B1 returns 7 1/4 for me,
when I format C1 the same as A1.

If, however, you were wanting to concatenate this to show, say, 7 1/4
inches, then =C1&" inches" will return 7.25 inches.
IF this is your problem, then use
=Text(C1,""# ?/?")&" inches"

--
Regards

Roger Govier


"jason2444" <[email protected]> wrote in message
news:[email protected]...
> using a formula to combine multiple cells. one of the cells has a
> fraction 5
> 1/4 . the results of the formula from the combined cells is
> converting the 5
> 1/4 to 5.25 how do I get the result of the formula to retain the 5 1/4
> fraction. I have tried formating the cell but that dosen't seem to
> work.
> Using excel 2002

Format the cell as

# ??/??

--

HTH

RP

"jason2444" <[email protected]> wrote in message
news:[email protected]...
> using a formula to combine multiple cells. one of the cells has a fraction
5
> 1/4 . the results of the formula from the combined cells is converting
the 5
> 1/4 to 5.25 how do I get the result of the formula to retain the 5 1/4
> fraction. I have tried formating the cell but that dosen't seem to work.
> Using excel 2002

let me explain a little better
A1 width
B1 5 1/4
C1 =a1&" "&b1
showing up as width 5.25
need to show up as width 5 1/4

thanks.

"Roger Govier" wrote:

> Hi Jason
>
> If I enter 5 1/4 in A1, and 2 in B1 in C1=A1+B1 returns 7 1/4 for me,
> when I format C1 the same as A1.
>
> If, however, you were wanting to concatenate this to show, say, 7 1/4
> inches, then =C1&" inches" will return 7.25 inches.
> IF this is your problem, then use
> =Text(C1,""# ?/?")&" inches"
>
> --
> Regards
>
> Roger Govier
>
>
> "jason2444" <[email protected]> wrote in message
> news:[email protected]...
> > using a formula to combine multiple cells. one of the cells has a
> > fraction 5
> > 1/4 . the results of the formula from the combined cells is
> > converting the 5
> > 1/4 to 5.25 how do I get the result of the formula to retain the 5 1/4
> > fraction. I have tried formating the cell but that dosen't seem to
> > work.
> > Using excel 2002
>
>
>

Hi Jason

Then try
=A1&" "&TEXT(B1,"# ?/?")

Apologies, an extra " had crept into my original formula!!!!

--
Regards

Roger Govier


"jason2444" <[email protected]> wrote in message
news:[email protected]...
> let me explain a little better
> A1 width
> B1 5 1/4
> C1 =a1&" "&b1
> showing up as width 5.25
> need to show up as width 5 1/4
>
> thanks.
>
> "Roger Govier" wrote:
>
>> Hi Jason
>>
>> If I enter 5 1/4 in A1, and 2 in B1 in C1=A1+B1 returns 7 1/4 for me,
>> when I format C1 the same as A1.
>>
>> If, however, you were wanting to concatenate this to show, say, 7 1/4
>> inches, then =C1&" inches" will return 7.25 inches.
>> IF this is your problem, then use
>> =Text(C1,""# ?/?")&" inches"
>>
>> --
>> Regards
>>
>> Roger Govier
>>
>>
>> "jason2444" <[email protected]> wrote in message
>> news:[email protected]...
>> > using a formula to combine multiple cells. one of the cells has a
>> > fraction 5
>> > 1/4 . the results of the formula from the combined cells is
>> > converting the 5
>> > 1/4 to 5.25 how do I get the result of the formula to retain the 5
>> > 1/4
>> > fraction. I have tried formating the cell but that dosen't seem to
>> > work.
>> > Using excel 2002
>>
>>
>>

hey thanks that was the ticket!

"Roger Govier" wrote:

> Hi Jason
>
> Then try
> =A1&" "&TEXT(B1,"# ?/?")
>
> Apologies, an extra " had crept into my original formula!!!!
>
> --
> Regards
>
> Roger Govier
>
>
> "jason2444" <[email protected]> wrote in message
> news:[email protected]...
> > let me explain a little better
> > A1 width
> > B1 5 1/4
> > C1 =a1&" "&b1
> > showing up as width 5.25
> > need to show up as width 5 1/4
> >
> > thanks.
> >
> > "Roger Govier" wrote:
> >
> >> Hi Jason
> >>
> >> If I enter 5 1/4 in A1, and 2 in B1 in C1=A1+B1 returns 7 1/4 for me,
> >> when I format C1 the same as A1.
> >>
> >> If, however, you were wanting to concatenate this to show, say, 7 1/4
> >> inches, then =C1&" inches" will return 7.25 inches.
> >> IF this is your problem, then use
> >> =Text(C1,""# ?/?")&" inches"
> >>
> >> --
> >> Regards
> >>
> >> Roger Govier
> >>
> >>
> >> "jason2444" <[email protected]> wrote in message
> >> news:[email protected]...
> >> > using a formula to combine multiple cells. one of the cells has a
> >> > fraction 5
> >> > 1/4 . the results of the formula from the combined cells is
> >> > converting the 5
> >> > 1/4 to 5.25 how do I get the result of the formula to retain the 5
> >> > 1/4
> >> > fraction. I have tried formating the cell but that dosen't seem to
> >> > work.
> >> > Using excel 2002
> >>
> >>
> >>
>
>
>