Use the second solution that I posted:

=A3&"/"&A4 which will show exactly what you want but you can't use for
arithmetic.

Regards

Trevor


"burnsbyrne" wrote
in message ...

It seems I spoke too soon (maybe). I tried out the solution suggested
by Trevor and Bruce and found that the fraction format also reduces the
fraction. E.g., 5/10 is displayed as 1/2. This is not good for my
purposes because the fraction 5/10 means 5 patients of a total of 10
received a particular treatment. Obviously, reducing that fraction
will not work. Does Excel always force the reduction? Is there a way
to turn it off?
Mike


--
burnsbyrne


------------------------------------------------------------------------
burnsbyrne's Profile:
http://www.excelforum.com/member.php...o&userid=22153
View this thread: http://www.excelforum.com/showthread...hreadid=390289