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