View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
frustratedbyautocorrect frustratedbyautocorrect is offline
external usenet poster
 
Posts: 1
Default How do I stop fractions from being reduced?

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?