Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel converts fractions into dates. Make it stop. | Excel Discussion (Misc queries) | |||
To Stop or Not to Stop | Excel Discussion (Misc queries) | |||
How to prevent Excel converting imported fractions into dates | Excel Discussion (Misc queries) | |||
Is there a way to stop fractions from being simplified? | Excel Worksheet Functions | |||
Stop Automatic Reduction of Fractions | Excel Discussion (Misc queries) |