Excel reduces fractions

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Go to costumize cells and the to custom and enter this # ?/12 The bottom
number of the fraction will always be 12
 
I had already done that, just didn't know if there was something else that
was already there to use.

Thanks.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Not reduce fractions 8
Reduced Fractions 1
How do I reduce fractions into lowest terms? 1
How do I get excel to NOT auto reduce fractions. 2
Reduction Fractions to LCD 7
Fractions 3
Fractions 5
Excel Excel and Fractions 3

Back
Top