Formatcells-Number tab
Under Category select custom
Under Type:
input this exactly
# ??/20

It will round every number to the closest 20th and display as fraction. If
you need other denominators, you will need to format each one seperately, or
format as text.

You are in the right place. When you select # ??/??, you should be able to
edit the text box under Type:

"mmiissttyy" wrote:

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)?