Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I keep a fraction as entered (leave 12/20 not 3/5)?
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)? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I keep a fraction as entered (leave 12/20 not 3/5)?
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)? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I keep a fraction as entered (leave 12/20 not 3/5)?
Interesting, you could format the cells TEXT, that keeps them from changing,
but when you try to do math with them using the VALUE function, it treats them as dates, eg, 5/10 returns a value of 38847, which is the DATEVALUE of May 10. Sorry I can't answer the question. "mmiissttyy" wrote: 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)? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I keep a fraction as entered (leave 12/20 not 3/5)?
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)? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I keep a fraction as entered (leave 12/20 not 3/5)?
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)? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I keep a fraction as entered (leave 12/20 not 3/5)?
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)? |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I keep a fraction as entered (leave 12/20 not 3/5)?
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)? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need additoinal symbols for fractions | Excel Discussion (Misc queries) | |||
Tracking annual leave | New Users to Excel | |||
Show two rows as a fraction? | Excel Discussion (Misc queries) | |||
FILL DATES IN VARIOUS CELLS BASED ON A DATE ENTERED IN A SINGLE C. | Excel Discussion (Misc queries) | |||
showing the # of times an item is entered in a column | Excel Worksheet Functions |