Site icon ExcelNotes

How to Turn Fractions No Integer

– 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.

Exit mobile version