How to Change Numbers to Fraction

- 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)".

Leave a Reply