Thanks -that's exactly what I want - only I don't know how to get that
formatting into Excel. How do I change the bottom ?? into 20? Am I in the
right place by going to Format...Cells...Custom ?

"RagDyeR" wrote:

Try this:

# ??/20

--

HTH,

RD
================================================== ===
Please keep all correspondence within the Group, so all may benefit!
================================================== ===

"mmiissttyy" wrote in message
...
I found # ??/?? under 'custom' but that did not work. Is there some other
way I can format the cell as ??/?? as you say? ~ Thanks.

"Bob Phillips" wrote:

Format the cell as ??/??

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"mmiissttyy" wrote in message
...
I need to have fractions show up as I enter them (12/20, 13/20, 15/20).
Is
there any way to keep Excel from changing those that can be (i.e. 12/20
to
3/5)?