MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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.


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