– How to Change the Numbers to Fraction
– How to Keep Fraction Denominator Digits
The fraction is commonly the mixed numbers: an integer and a proper fraction. To get rid of the integer part and turn it to part of the nominator, e.g., turn "2 1/5" into "11/5", please follow the steps below:
Step 1: Select the data range with fraction;
Step 2: Right click to bring up the dialog box, from the list click "Format Cells";
Step 3: In the "Format Cells" window, click "Custom" from the left navigation, then change the format "# ?/?" to "?/?";
– If the denominator is a number with two digits, please change "# ??/??" to "??/??";
– If the denominator is a number with three digits, please change "# ???/???" to "???/???";
Step 4: Click "OK" at the bottom.