Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel reduces fractions
I am trying to enter fractions to represent a quantity of months of the year
(i.e., 2/12, 3/12, etc.) for a calculation. Excel insists on reducing these to their lowest terms (1/6, 1/4, etc.). Can I prevent this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel reduces fractions
Go to costumize cells and the to custom and enter this # ?/12 The bottom
number of the fraction will always be 12 "Traci P." wrote: I am trying to enter fractions to represent a quantity of months of the year (i.e., 2/12, 3/12, etc.) for a calculation. Excel insists on reducing these to their lowest terms (1/6, 1/4, etc.). Can I prevent this? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel reduces fractions
I had already done that, just didn't know if there was something else that
was already there to use. Thanks. "James O" wrote: Go to costumize cells and the to custom and enter this # ?/12 The bottom number of the fraction will always be 12 "Traci P." wrote: I am trying to enter fractions to represent a quantity of months of the year (i.e., 2/12, 3/12, etc.) for a calculation. Excel insists on reducing these to their lowest terms (1/6, 1/4, etc.). Can I prevent this? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel reduces fractions
On Wed, 18 Apr 2007 11:36:00 -0700, Traci P.
wrote: I had already done that, just didn't know if there was something else that was already there to use. Your response leads me to believe that what you did is not having the desired effect. Is that the case or are you looking for something else? What James described does work. --ron |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I have excel convert fractions to decimals? | Excel Worksheet Functions | |||
Formatting Numbers and Fractions in Excel | Excel Discussion (Misc queries) | |||
How can I force Excel to do fractions in super/sub script | Excel Discussion (Misc queries) | |||
how do i create a reducing number that reduces at certain dates | Excel Discussion (Misc queries) | |||
fractions in excel | Excel Discussion (Misc queries) |