How do I stop fractions from being reduced?

  • Thread starter frustratedbyautocorrect
  • Start date
F

frustratedbyautocorrect

I formatted cells in a column as fractions up to two numbers(21/20), and when
I put in fractions that can be reduced, excel does it automatically. I don't
want this to happen because I'm going to turn it into a graph and tables and
it is easier to see rates of change when the fractions aren't reduced. How do
I stop this?
 
R

Ron Rosenfeld

I formatted cells in a column as fractions up to two numbers(21/20), and when
I put in fractions that can be reduced, excel does it automatically. I don't
want this to happen because I'm going to turn it into a graph and tables and
it is easier to see rates of change when the fractions aren't reduced. How do
I stop this?

You may be overlooking the fact that the numbers stored in the cells are not
changed by changing the format. In other words, unless you store a value as
TEXT (which would probably make it useless for your purposes), the value
1 49/98

is going to be stored as (the binary equivalent of) 1.5.

The fractional formatting only changes how the value is displayed in the cell.

So far as the graph or table is concerned, you will probably need to format the
axis or table cells separately.

You could format them as showing a chosen denominator -- e.g.:

# ?/16

would display the value in 16ths.


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

Top