Cell Formatting
 

I am working on a project where I'm dividing two cells both with the
identical data (316.44) in each. Of course my result is "1", unfortunately
though I need to force the answer to be 1/1 (represented as a fraction). Is
there a way to do this? Thank you!

Hi

if the answer doesn't have to be a number how about
=A2/B2&"/"&A2/B2

--
Cheers
JulieD
check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"askin4urhelp" wrote in message
...
I am working on a project where I'm dividing two cells both with the
identical data (316.44) in each. Of course my result is "1",
unfortunately
though I need to force the answer to be 1/1 (represented as a fraction).
Is
there a way to do this? Thank you!

Custome format ?/?

Regards,

Peo Sjoblom

"askin4urhelp" wrote:

I am working on a project where I'm dividing two cells both with the
identical data (316.44) in each. Of course my result is "1", unfortunately
though I need to force the answer to be 1/1 (represented as a fraction). Is
there a way to do this? Thank you!