- How to Keep Fraction Denominator Digits
- How to Turn Fractions No Integer
A fraction is expressed as one number over another number. When working with data, you may need to change some numbers to fractions, please see the steps below for details:
Step 1: Select cells or the data range with numbers;
Step 2: Right click to bring up the dialog box, from the list click "Format Cells";
Step 3: In the "Format Cells" window, click "Fraction" from the left navigation;
Step 4: Click "OK" at the bottom.
Please note that this is to keep the denominator up to one digit.
- To keep the denominator up to two digits, please select "Up to two digits (21/25)";
- To keep the denominator up to three digits, please select "Up to three digits (312/943)".