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

converting decimals to fractions
 

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" wrote in message
...
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

converting decimals to fractions
 

Format the cell as

# ??/??

--

HTH

RP

"jason2444" wrote in message
...
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

converting decimals to fractions
 

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" wrote in message
...
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

converting decimals to fractions
 

Hi Jason

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

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

--
Regards

Roger Govier


"jason2444" wrote in message
...
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" wrote in message
...
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

converting decimals to fractions
 

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" wrote in message
...
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" wrote in message
...
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