WPS Office

Free All-in-One Office Suite with PDF Editor


Edit Word, Excel, and PPT for FREE.


Read, edit, and convert PDFs with the powerful PDF toolkit.


Microsoft-like interface, easy to use.

Free Download

Windows • MacOS • Linux • iOS • Android


Data format - Fraction format

Uploaded time: March 1, 2022 Difficulty Beginner

Data format - Fraction format

Data format - Fraction format

Do you know how we can convert a number into the fraction format?

There are two available methods to set fraction format in WPS Spreadsheet.

First, select the range of the table, head to the Home tab,  find the setting button in the shortcut menu, and set the Fraction format.

Alternatively, we can select the desired range of cells, and right-click Format cells, whose shortcut key is Ctrl+1.

Locate Fraction in the category list, and choose from different types of fractions in the Type area on the right.

Here, we can specify the denominator to fixed-length or designated value as needed.

Besides, the format effect can be previewed in the preview box above.

Choose the desired type, and click OK to finish this operation.

More often than not, when inputting fractions in the worksheet, we may find the fractions are recognized as date format or text format.

Now, we'll learn about how we caninput fractions of correct format. The method is easy to master once you add a space between the fractional part and the integer part.

For example, in case we want to enter 1/4, we can input 0 first,and then enter a space,and then input 1/4. Now, we've successfully input a correct fraction.

The above is how we can set fraction format. Did you get it?

15 years of office industry experience, tech lover and copywriter. Follow me for product reviews, comparisons, and recommendations for new apps and software.