Not reducing fractions
Posted by Mel on January 04, 2001 6:48 PM
I want to combine data from 2 cells containing simple numbers (e.g. 4 & 6) to make a numerical fraction. Excel automatically reduces this fraction; I need the actual numbers to show as data labels in a chart.
Help!
Posted by cpod on January 04, 2001 8:16 PM
If you are just going to use it as a label you can create a text string:
If A1 = 2
A2 = 4
=A1 & "/" & A2
will return the text string 2/4
Posted by CJ on January 27, 2001 7:49 PM
Posted by CJ on January 27, 2001 7:55 PM
Can you help me Mel in wanting to enter fractions in cells (i.e., 3/12, 200/400) without it automatically reducing and still retain numerical value? I enter fractions as my raw data and then graph the results on a percentage scale (excel will convert the fraction to a decimal, then to percentage, but want to show values without the fractions reducing)????
